SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Bought this book as a refresher and reference guide to things I did not already know. Great for a beginner

Great book, I learned a lot. When learning a topic as sophisticated as this, sequence and reference backs to spots in the book is important. He did a good job with this. Plenty of examples and actionable as well. He also had some opinions about what to use caution with but not biased to "his" way of doing things.

ConclusionThis book covers a wide range of performance topics and techniques, with the central aim of improving the performance of your SQL workload. It is generally easy to read, with practical step-by-step walkthroughs, helpful links between chapters and to websites, and good use of screenshots. Typically, code is provided to back up the assertions made. The book should take your level of expertise from level 3 to level 8 (based on a 1 to 10 scale).While this book covers most code-based performance topics, there were times when I wanted more detail. There was no mention of the more advanced performance tools like SQLDIAG or SQL Nexus. Sometimes the structure of the book felt awkward (e.g. perfMon is explained in the memory chapter but its example usage is given in a later chapter). Having a separate detailed tools chapter, that is repeatedly referenced, may have been better.This book is very similar to the 2014 edition of the book, while the screenshots have been updated for 2017, the text is perhaps 70% the same or similar (2 new chapters have been added). Although written for SQL Server 2017, much is applicable to 2014 and earlier. If you want a good, wide ranging, SQL code optimization book, I can certainly recommend this book.

Como administrador de bases de datos buscaba un libro que me ayudara en mi trabajo y me diera otro enfoque ante problemas de performance-rendimiento.La verdad es que estoy encantado, las explicaciones son claras y los ejemplos ayudan un montón. Toca todo tipo de herramientasy temas: vistas dinamicas, performance monitor, index, trazas...Ademas hay scripts muy útiles válidos para usar en el día a dia.Lo único es que considero que debesuna buena base para entender el libro, ya que no esta hecho para principiantes.

Excelente livro. Didática fácil de entender