- 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
-
Below is indexer declaration : modifier return type this [argument list] { get { // Get codes goes here } set { // Set codes goes h...
-
1. An indexer is identified by it's signature. But a property is identified it's name. 2. An indexer is always an instance member,...
-
You can add public events for Httpmodule using below syntax i.e ModuleName_OnEventName in Global.asax . Example Session_OnStart ( Obj...
-
The steps to create custom HTTP module are : Implement IHttpModule Interface Handle Init Method and register events one needs Handle t...
-
Please do below steps to make SQLServer session mode to work properly : 1. To use SQLServer mode, you must first be sure the ASP.NET sessi...
-
Replication is the way to keep data synchronised in multiple datbases. SQL Replication consists of two important part : Publisher - Datab...
-
Different types of primary behaviours are as follows : Service Behaviour Endpoint Behaviour Operation Behaviour Callback Behaviour
-
Cache object belongs to System.Web.Caching namespace.
-
Different security mechanisms used in SQL Server : Logins Users Roles Groups
-
SQL Constraints are used to enforce integrity of database.
No comments:
Post a Comment