SQL Server - Identifying and Resolving Deadlock
This is an attempt to demonstrate on how to identify and resolve a deadlock in SQL Server. A practical example creates a deadlock first and then using Error Log / SQL Profiler trace, the deadlock is resolved by creating proper indexes on the tables