SQL Server Query Performance Tuning

The latest update to my book, SQL Server Query Performance Tuning was released last week. This is the fourth edition of the book, and the third edition that I’ve been responsible for. At the urging of my editor, Jonathan Gennick, I have completely restructured the book for this release. The chapters have been broken up and rearranged so that they’re smaller, more easily consumed. Yes, I’ve worked with my technical editor, Joe Sack, to add lots of new information and to ensure that the existing information is more accurate and more useful. But, we’ve also added new chapters on topics that weren’t given enough attention in the previous versions of the book, such as parameter sniffing. It can certainly seem like these book releases are just some incremental changes on top of existing information, but not this time. This is a new book, with a new structure and new material (almost 80 pages worth), but, hopefully, with all the usefulness of the old book fundamentally intact. Please check it out.

If reading books isn’t your thing, or, you just want some personal interaction to assist your learning, I’ll be doing an all day, pre-conference seminar on query tuning at the PASS Summit this year, 2014. Go here to register.

8 thoughts on “SQL Server Query Performance Tuning

  • Mitul

    I have just begun my career as a software engineer and have a 2 month hands on experience in T-SQL. Can this book be useful to me as a beginner level developer?

  • We released a brand new version, all new chapters, completely updated content, in 2014, that included up to the minute material. However, things are shifting, very fast. I decided to not do a 2016 release of the book, but it looks like 2017 is going to see another release. I’ll start working on an update shortly after that comes out so that I’m as up to date as I can be.

    I am releasing a new version of the Execution Plans book a little later this year.

  • BTW, with the exception of Query Store, most of 2016 is not radically different than 2014. 2014 was radically different than 2012, but that last update wasn’t as big. 2017 looks to be somewhat incremental, but it’ll be big enough that it makes sense to update the book.

Please let me know what you think about this article or any questions:

This site uses Akismet to reduce spam. Learn how your comment data is processed.