I don't know if this affects other people, but I often have problems deciding which books I want to buy and or read. So in an attempt to assist others in making good book choices with what may be limited funding, that I will provide a brief review of my opinion of the books that I have read and or am currently reading. Since I have quite a stack that I have read, I figured I would start off with my favorite SQL Server 2005 Book.
SQL Server 2005 Practical Troubleshooting: The Database Engine (SQL Server Series) by Ken Henderson (Paperback - Dec 18, 2006)
This in my opinion has to be one of the best resources for a SQL Server DBA when all hell breaks loose and there are serious problems with a SQL Server. If you don't have a copy of it yet, I would highly recommend it. Unlike most of the books that are out there, this book was written by the developers at Microsoft for SQL Server, and edited by the late Ken Henderson, whose own contributions to the SQL Community over the years was second to none. This book gets down into the nitty gritty of SQL Server, how it functions and why, and how to resolve and troubleshoot some of the most complex problems with the Database Engine.
What is really good about this book is that it provides in depth information and details that could only come from the internal development staff at Microsoft. The book is divided into specific problem types and details to include stack dump data is included in the book text to demonstrate the problem being explained.
Chapter 1 Waiting and Blocking Issues
Chapter 2 Data Corruption and Recovery Issues
Chapter 3 Memory Issues
Chapter 4 Procedure Cache Issues
Chapter 5 Query Processor Issues
Chapter 6 Server Crashes and Other Critical Failures
Chapter 7 Service Broker Issues
Chapter 8 SQLOS and Scheduling Issues
Chapter 9 Tempdb Issues
Chapter 10 Clustering Issues
One problem reported with the book is that Amazon lists it as coming with a CD included. Mine didn't, and I am not concerned about it, but I'll provide the warning that you won't get a CD with your book if you order it. Additionally, expect that it will take 3-4 weeks to get delivery of the book if you do order it online. I am not sure why it took so long to arrive, but it was definitely worth the wait.