Deadlocks due to Partition Level Lock Escalation

SQL server Guru Paul Randal (b | t) explains how enabling partition level lock escalation can cause deadlocks in the post Partition level lock escalation – details and examples.

This post is part of the series SQL Server deadlocks and live locks – Common Patterns. If you have questions, please post a comment here or reach me at @sqlindian