SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: September 2010

Range locks do not only occur in Serializable transactions....

According to BOL, "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".  From this I took it to mean that Range locks are ONLY used in Serializable transactions.

So then I had to… Read more

2 comments, 969 reads

Posted in Sam Bendayan's 2 Cents on 22 September 2010