http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/05/26/range-locks.aspxLately I have seen some quesitons on range locks. Why certain keys are locked? How is this behavior different for unique vs. non-unique indexes? So I played around with range locks and here are my findings so far. Range locks are obtained on index keysen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/05/26/range-locks.aspx#612263Thu, 01 Jun 2006 00:28:56 GMT91d46819-8472-40ad-a661-2c78acb4018c:612263SimonS Thanks to Euan for pointing out that Sunil from the Storage Engine team has started a blog. This continues...<img src="http://blogs.msdn.com/aggbug.aspx?PostID=612263" width="1" height="1">http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/05/26/range-locks.aspx#612262Thu, 01 Jun 2006 00:28:56 GMT91d46819-8472-40ad-a661-2c78acb4018c:612262SimonS' SQL Server StuffThanks to Euan for pointing out that Sunil from the Storage Engine team has started a blog. This continues...<img src="http://blogs.msdn.com/aggbug.aspx?PostID=612262" width="1" height="1">