Subscribe to this blog
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, 278 reads
Posted in Sam Bendayan's 2 Cents on 22 September 2010