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 » internals » Locks   (RSS)
  • Read Committed isolation level, indexed views and locking behavior

    From BOL, "Key-Range Locking" article: Key-range locks protect a range of rows implicitly included in a record set being read by a Transact-SQL statement while using the serializable transaction isolation level. The serializable isolation level requires that any query executed during a transaction must obtain the same set of rows every ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on March 15, 2011
  • T-SQL Tuesday #006: LOB, row-overflow and locking behavior

    This post is my contribution to T-SQL Tuesday #006, hosted this time by Michael Coles. Actually this post was born last Thursday when I attended Kalen Delaney's ''Deep dive into SQL Server Internals'' seminar in Tel-Aviv. I asked question, Kalen didn't have answer at hand, so during a break I created demo in order to check certain behavior. Demo ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on May 10, 2010
Privacy Statement