Pro SQL Server Internals

I used this book to study for my Microsoft MCSA 70-762 exam for SQL Server, and I don't think I would've passed the test without it. This was, by far, the most helpful book in all of my dozens of study materials for that beast of an exam. This is NOT light reading, and it is NOT a book for beginners. It dives into very, very deep topics. An advanced level of knowledge and experience with SQL Server is definitely a prerequisite for this book.

Fantastic book on the storage and performance internals of SQL Server. Don't expect tips on administration best practices or T-SQL features for developers. However, if you want to understand how SQL Server is really working all the way up to 2016, this is a great book. However, grasping the concepts in this book *will* allow you design better performing databases and write more efficient queries. Would highly recommend for anyone doing database development or administration on SQL Server, particularly with the recent updates to features such as ColumnStore indexes, which really change the storage mode of the table.

This is an incredible book on SQLServer Internals! Any DBA should have this gem on their shelf. There are several great examples and scripts to bring over to your toolbox. I really enjoyed the explanations, examples and scripts to see for yourself. Grab this book and get a much better example of how things work under the covers.

Very in-depth book that explains the "why" behind many things. I had my MCSA: SQL Server 2012/2014 before reading this, and I'm still learning a ton from it. There are lots of code examples and comparative benchmarks for different approaches, which is extremely helpful.

Very helpful top notch insights not a regurgitated manual

This is a VERY well written book on SQL Server internals with a wealth of content! I only read through Chapter 3 so far and I can't wait to finish reading the rest of the book!

Awesome book on SQL internals.

Best written book for SQL Server