Disable Lock Escalation in SQL Server April 10, 2015 If a lot of rows or pages are locked, the SQL Server escalates to a table-level lock, to save...