I was recently trying to diagnose some problems in one of my SQL Servers when I ran across a problem that I hadn’t encountered before involving ‘nonyielding worker threads’.  SQL Server also produced a dump for me to review.  Unfortunately, the dump didn’t make a lot of sense to me. 

If you encounter one of SQL Server’s mini-dump files and want more information, you’ll be happy to know that there’s a lot of information on-line:

http://www.microsoft.com/technet/prodtechnol/sql/2005/diagandcorrecterrs.mspx

This URL is also a wealth of diagnostic and internals information that I recommend for any serious SQL Server professional.

Enjoy!

-Kev

P.S. And check out the new CD by Paramore - best alt rock CD of the year IMO.