Read Committed isolation level, indexed views and locking behavior

Posted by Michael Zilberstein on SQL Blog See other posts from SQL Blog or by Michael Zilberstein
Published on Tue, 15 Mar 2011 14:31:43 GMT Indexed on 2011/03/15 16:16 UTC
Read the original article Hit count: 348

Filed under:
|
|
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 time it is executed during the transaction. A key range lock protects this requirement by preventing other transactions from inserting new rows whose...(read more)

© SQL Blog or respective owner

Related posts about internals

Related posts about locks