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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement