THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Isolation Levels   (RSS)
  • Pros and Cons of Using Read-Uncommitted and NoLock

    Definitions Read-Uncommitted Isolation Level The read-uncommitted isolation level is the least restrictive isolation level within SQL Server, which is also what makes it popular for developers when looking to reduce blocking. Blocking is “typically” not an issue when using this isolation level because the query will not request shared (S) locks ...
    Posted to Tamarick Hill (Weblog) by Tamarick Hill on May 6, 2013
  • Snapshot isolation and SQL Server 2000 compatibility level

    What is the simplest test to see the snapshot isolation level at work?   There was a question in one of the forums on whether you can use the snapshot isolation level in a SQL Server 2005 database that is in the SQL2000 compatibility level. I don’t know what may be the official answer from the Books Online. It may be documented somewhere, ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on September 25, 2009
Privacy Statement