- 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
-
How to pass null values to stored procedure from code behind ? Pass the parameter’s value as DBNull.Value from code-behind.
-
New Data types in SQL Server 2008 are : DATE - occupies 3 bytes . Has accuracy of 1 day . Data stored in 'YYYY-MM-DD' format TIME...
-
Question : State whether below class relationship is correct or not . If not why ? class A: B {} class B: C {} class C: A {} Answer...
-
Different validation controls in ASP.NET are as follows : RequiredFieldValidator CompareValidator RangeValidator RegularExpressionValida...
-
Types of DML statements : Select Insert Update Delete
-
Use window.location i.e window.location="http://www.redirectpage.com/redirect.html";
-
Authentication is process of obtaining credentials such as username and password and validating the credentials. There are 3 types of ASP....
-
WCF stands for Windows Communication Foundation. WCF was introduced with .NET Framework 3.0. It provides combined features of Web Services ,...
-
Normalization is a method to seperate data into multiple tables and relate these multiple tables. Some benefits of normalized database : 1)...
-
public class Operation { public int Add ( int a , int b ) { return (a+b); } } We have to call above method using delegate Steps below : D...
No comments:
Post a Comment