Understanding SQL Server Deadlocks

This is a continuation of a series of articles I've written on SQL Server concepts. When you work with SQL Server long enough on a database with enough traffic, you're eventually going to encounter deadlocks. This article discusses what deadlocks are, how to interpret deadlock graphs, and some options for handling deadlocks.