Explain different isolation levels
Page 1 of 1
Explain different isolation levels
by Micheal Tue Jan 12, 2010 8:40 pm
An isolation level determines the degree of isolation of data between concurrent transactions. The default SQL
Server isolation level is Read Committed. Here are the other isolation levels (in the ascending order of
isolation): Read Uncommitted, Read Committed, Repeatable Read, Serializable. See SQL Server books online for
an explanation of the isolation levels. Be sure to read about SET TRANSACTION ISOLATION LEVEL, which lets
you customize the isolation level at the connection level.
Server isolation level is Read Committed. Here are the other isolation levels (in the ascending order of
isolation): Read Uncommitted, Read Committed, Repeatable Read, Serializable. See SQL Server books online for
an explanation of the isolation levels. Be sure to read about SET TRANSACTION ISOLATION LEVEL, which lets
you customize the isolation level at the connection level.
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» What Are Transaction Isolation Levels Supported by Oracle?
» How To Manage Transaction Isolation Level?
» What is a self join? Explain it with an example.
» What is a join and explain different types of joins.
» Explain the relationship among Database, Tablespace and Data file.?
» How To Manage Transaction Isolation Level?
» What is a self join? Explain it with an example.
» What is a join and explain different types of joins.
» Explain the relationship among Database, Tablespace and Data file.?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Accessing tables of other users in SQL
» Grouping commands in SQL
» Operations on Result Sets in SQL
» Subqueries in SQL
» Joining Relations in SQL
» Delete comand in SQL
» Update command in SQL
» Insert command in SQL