http://msmvps.com/blogs/laflour/pages/net-tips-sql-t-sql.aspxback to content INFO: SQL Server starts with row-level locks, but often escalates these to page and table locks, causing deadlocks >> . new If the physical or logical RID contained in the non-clustered index records needs to change then all theenCommunityServer 2008.5 SP2 (Build: 40407.4157)