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 ...

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 ...