One more book review 🙂 (It’s really nice having a long holiday to read books and relax).
This is also a “Must have book”; simply because Indexing is so important for good performance. Indexing is always a trade off between better read access to data versus storage and degrade in write performance, and I think this book gives you the tools to support your decisions when you are working with the part of performance that are related to indexing.
No doubt that my favorite chapter is the chapter about Myth’s when it comes to indexes. All persons working with SQL servers should read that chapter.
With this book you first get an insight into what indexes are, what types of indexes there is and what statistics are (statistics is critical to know in relation to performance optimization).
The book also describes some of the tools that are important to know when you want to work with indexes (including the most important DMO’s).
Finally I also like that the book gives you some good advices (they call it best practice and strategies) on how to write queries and how to use indexes.
Overall a very competent book (I think all books from APress is competent).
On the negative side, then it is easy to see that this book is an upgrade from the same book on SQL Server 2008, and one of the places where that is seen is when they discuss Column store indexes. It is few pages and it is absolutely NOT Expert knowledge what they give you.
I am not sure it is a negative thing, but the book is called “Expert performance….”. I think this book can be read and should be read by anyone that has been working with the Microsoft SQL server 2012 for more than 6 month to 1 year. It could be a good starting point for going deeper into the Microsoft SQL server.
I think this book is worth buying and I give it 3 out of 5 stars.