Disable Lock Escalation in SQL Server

If a lot of rows or pages are locked, the SQL Server escalates to a table-level lock, to save resources. Each single ...