SQL Server Lock Escalation explained
Hi Friends, I wrote a blog post on partition-level locking where I demonstrated how locks are escalated from row to partition. The blog post is here; A few readers wrote back to me asking when does SQL Server escalate the row locks to table or partition level locks. So in this post, I will talk [...]