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

not bad book

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.This book covers most code-based performance topics. The book should take your level of expertise from level 3 to level 8 (based on a 1 to 10 scale).The author claims the book is a rewrite, but I suggest it is at least 80% similar to the previous edition – but with some (relatively) small updates for SQL Server 2022. This is to be expected since the fundamentals don’t really change. There are two new chapter (Graph Databases, and Intelligent Query Processing), and several other chapters have been merged or split. Additionally, some chapters have been dropped. Some of these dropped chapters are quite interesting (e.g. Database Workload Optimization - a useful case exercise, applying many features learned in the book), it must have been difficult for the author to decide which chapters to omit. Please see my review of the previous version of this book for further details.Although written for SQL Server 2022, much is applicable to SQL Server 2017 and earlier versions. If you want a solid, wide ranging, SQL code-based optimization book, I can highly recommend this book.

Not too bad