
Snapshot Isolation Adds Flexibility in SQL Server 2005
QL Server uses isolation levels to govern the tradeoff between consistency of transactions and concurrency of multiple users. As you raise a transaction’s isolation level, you also increase the chances that a transaction’s reads may block and deadlock with other transactions. Even with the relatively low default READ COMMITTED isolation