Outstanding Reference Book

I have been a DBA for a bunch of small sites for many years. Recently I committed to a job w/ a large, online OLTP retailer and needed to fine tune my knowledge of the SQL Server engine.

I was shocked at just how flawed/lacking my knowledge was after reading this book.

Let me first state this sucker isn't for people looking to get by using the Enterprise Manger GUI. This book dissects the inner most workings of the db engine and it's under lying theory. Their is a lot of TSQL. I found myself limited to reading only a small number of pages at a time and then needing a break. The book is that intense and I have a Masters of Science degree as well as MCDBA and MCITP certifications.

Probably my favorite feature of the book is its small size, under 400 pages from tip to tail. I'd suggest this book to anyone wanting an understanding of what they are actually doing in SQL Server when they issue commands from EM. This book should be a requirement for any DBA or DB Designer in my opinion.

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