Bart Duncan has a great blog entry on Deadlock Troubleshooting that I am sure will come in very handy at some point in the future. It explains the root causes of deadlock problems and goes through some useful steps on how to prevent them. This is much better than going wild with NOLOCK hints like many developers and DBAs tend to do in a deadlock situation.
The Windows Server team has just released the August 2006 CTP of Longhorn Server for MSDN and TechNet subscribers. I’ll be downloading it in a bit, since I want to try out IIS 7 and I want to see how SQL Server 2005 runs on Longhorn Server.
Technorati Tag: SQL Server