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:
This URL is also a wealth of diagnostic and internals information that I recommend for any serious SQL Server professional.
P.S. And check out the new CD by Paramore - best alt rock CD of the year IMO.