Database - SQL Server 2000 - Discussion
Discussion Forum : SQL Server 2000 - General Questions (Q.No. 4)
4.
The strictest transaction isolation level provided by SQL Server is called:
Discussion:
3 comments Page 1 of 1.
Gursimran said:
7 years ago
Thank you so much for explanation @Pankaj Desi.
Pankaj Desai said:
8 years ago
The highest isolation level, serialize, guarantees that a transaction will retrieve exactly the same data every time it repeats a read operation, but it does this by performing a level of locking that is likely to impact other users in multi-user systems.
Whereas the lowest isolation level, read uncommitted, may retrieve data that has been modified but not committed by other transactions. All of the concurrency side effects can happen in read uncommitted, but there is no read locking or versioning, so overhead is minimized.
Whereas the lowest isolation level, read uncommitted, may retrieve data that has been modified but not committed by other transactions. All of the concurrency side effects can happen in read uncommitted, but there is no read locking or versioning, so overhead is minimized.
Anand said:
1 decade ago
Serializable only security mode thats why.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers