Monthly Archives: August 2012

Boyce – Codd Normal Form (BCNF)

Posted on August 19, 2012 by vivekjohari

Boyce – Codd Normal Form (BCNF)  :- A normal form is said to be a Boyce – Codd Normal Form if it is in 3NF and there is not a possibility of a key attribute is determined by a Non Key attribute. … Continue reading →

Posted in SQL Normalization, SQL Server | Tagged , | 8 Comments

Isolation levels in SQL Server

Posted on August 19, 2012 by vivekjohari

Isolation levels :- Isolation level is required to isolate a resource and protect it from other transactions. This is achieved with the help of locks but what locks are needed and how they can be established is decided on the … Continue reading →

Posted in SQL Isolation Level, SQL Server | Tagged , , | 33 Comments