Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Isolation Level... » Scans and Seeks   (RSS)
Sorry, but there are no more tags available to filter with.

Repeatable Read Isolation Level

In my last two posts, I showed how queries running at read committed isolation level may generate unexpected results in the presence of concurrent updates. Many but not all of these results can be avoided by running at repeatable read isolation level.

Read Committed Isolation Level

SQL Server 2000 supports four different isolation levels: read uncommitted (or nolock), read committed, repeatable read, and serializable. SQL Server 2005 adds two new isolation levels: read committed snapshot and snapshot. These isolation levels determine
 
Page view tracker