Best overall for SQL Server Tuning

I am a SQL Server performance consultant to many large corporations and government agencies. I have read and re-read this book so many times I should know it by heart. Still, I carry it with me on consulting engagements everywhere I go. There is almost always someone at my client's site who wants to improve their performance tuning skills. I show them the book and tell them this is where you start.

I don't know if there will be a version specifically for 2005, but it really doesn't matter much. The central concepts of the book have not changed for SQL Server 2005.

Ken England's writing style is clean and lucid. He can explain complex issues in a remarkably understandable way. His explanation of indexes and strategies of indexing is a great example of readable technical writing. He also has a good understanding of what is important and what is not.

This book is accessible to anyone who has some experience with SQL Server or any relational database. Someone with little experience may not get it all in one pass, but they will be much better prepared for real-world SQL Server performance tuning.

Other Reviews

• 9 years later, still valid, still one of the best MS-SQL perf. tuning books
• Outstanding Reference Book
• SQL best practices bible
• Best overall for SQL Server Tuning
• Best book on performance tuning