How to simulate a SQL deadlock for testing purposes
Deadlock monitoring and management tools
Deadlock resolution techniques in SQL Server
Deadlock detection techniques in SQL Server
Deadlock prevention techniques in SQL Server