SQL Server deadlocks and Live Locks–Common Patterns
I get to play with a lot of deadlocks these days, part by chance and part by choice. So I thought it is a good idea to start a blog series about handling different types deadlocks and live locks (yes live locks!)
I will try to establish some context about general deadlock properties and then introduce you to some common and some not so common deadlock patterns.
Note: The scripts mentioned in the articles are tested only in SQL server 2008 R2 unless mentioned otherwise.