The UserID clustered index is a good thought and we actually tried that last night. Though logically it should have helped the fragmentation still grew substantially by the end...

Very interesting news about SQL 2008 and Extended Events. I'm looking forward to when we can upgrade our production servers to that.

For now the WMI deadlock system has provided...

Great article on investigating the deadlock. Just a note that if you're running SQL 2005/2008, the trace flag 1222 (http://msdn.microsoft.com/en-us/library/ms178104.aspx) provides a lot more information so you...