- Read Uncommitted - Lowest level of isolation . Uncommitted data can be read . Hence we will have Dirty Read , Nonrepeatable read and Phantom record. Shared and exclusive locks are not honoured .
- Read Committed - This is SQL's default isolation level . Uncommitted data cannot be read. It allows inserts and deletes. Shared locks are held hence dirty read is avoided but we still have Nonrepeatable read and Phantom record
- Repeatable Read - It prevents data updation . Locks are placed on the data , preventing other users from updating the data. Prevents non-repeatable reads but phantom rows are still possible.
- Serializable - Highest level of isolation . Prevents other users from updating or inserting rows into the dataset until the transaction is complete . We don't have Dirty Read , Nonrepeatable read and Phantom record
What are different isolation levels in SQL Server?
Isolation level in SQL Server are as follows :
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Cache Callback provides an ability where by some actions can be performed when that item is removed from cache CacheItemRemovedCallback ex...
-
XML DOM loads the entire xml document into memory whereas Simple API for XML ( SAX ) does not load entire xml document into memory XML DOM ...
-
Different types of diagrams in UML : UseCase diagram Class diagram Object diagram State diagram Sequence diagram Collaboration diagram...
-
Virtual-Override and New Class Child inherits from Class Parent and has mehtod ShowVirtualOverride() and ShowNew() methods. Please see th...
-
Question : Name few C# 3.0 enhancements ? Answer : The C# 3.0 language enhancements are as follows: Implicitly typed local variables I...
-
If locaction attribute is specified, must be one of: Any, Client, Downstream, None, Server or ServerAndClient.
No comments:
Post a Comment