Excellence in SQL Server

Recently I was working on a SQL Server that had the following trace flags enabled. 1204 and 1222 for deadlocks. 1117 uniform tempdb...

Detecting and resolving deadlocks in SQL Server can be difficult. By default deadlock detection is not enabled. Deadlocks can cause data...