Yesterday an article I wrote on troubleshooting deadlocks in SQL Server 2005 was published on the SQL Server Central site. Its a quick, straight to the point article on how to use SQL Server Profiler to extract deadlock graphs for further analysis. This is a very common question on both the SSC forums and the MSDN forums.
Using SQL Profiler to Resolve Deadlocks in SQL Server
In December I spent a day in Orlando with Andy Warren from JumpStartTv.com recording a series of 3-5 minute videos on a couple of different SQL Server Topics, the main one being working with Deadlocks in SQL Server. Today the first of those videos was featured on the JumpStartTv.com site:
Setting Deadlock Priority