Until the release of SQL Server SP1 I though I had a good understanding of how deadlocks can occur in SQL Server. Well, SP1 has changed this view quite dramatically by introducing self deadlocking transactions.
Let us look at a very simple example,
Read More