Lock Escalations – do they always happen?
I blogged some time ago about the basics of Lock Escalations in SQL Server, and how even the plan shape can influence Lock Escalations. Today I want to talk further about Lock Escalations: do they always happen? When does a Lock Escalation happen? In general a Lock Escalation happens in SQL Server if you have …