SQL Server Query Tuning and Optimization
Optimize Microsoft SQL Server 2022 queries and applications
Benjamin Nevarez
BIRMINGHAM—MUMBAI
SQL Server Query Tuning and Optimization
Copyright © 2022 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing or its dealers and distributors, will be held liable for any damages caused or alleged to have been caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
Publishing Product Manager: Apeksha Shetty
Content Development Editor: Joseph Sunil
Technical Editor: Rahul Limbachiya
Copy Editor: Safis Editing
Project Coordinator: Farheen Fathima
Proofreader: Safis Editing
Indexer: Rekha Nair
Production Designer: Joshua Misquitta
Marketing Coordinator: Nivedita Singh
First published: Aug 2022
Production reference: 1210722
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham
B3 2PB, UK.
ISBN 978-1-80324-262-0
Contributors
About the author
Benjamin Nevarez is a database professional based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of several books including “SQL Server Query Tuning & Optimization”, “High Performance SQL Server”, “SQL Server 2017 on Linux”, and “Inside the SQL Server Query Optimizer” and has also coauthored other books such as “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences around the world. His blog can be found at http://www.benjaminnevarez.com and he can also be reached on twitter at @BenjaminNevarez and Facebook at https://www.facebook.com/BenjaminNevarez
About the reviewers
Mark Broadbent is a Microsoft Data Platform MVP and Microsoft Certified Master in SQL Server with over 30 years of IT experience working with data. He is an expert in transaction processing and concurrency control, a lover of Linux, development, Cloud, and Retro computing. In between annoying his long-suffering wife Lorraine and being beaten at video games by his children Lucy and Max, he can be found lurking on Twitter as @retracement.
Brandon Leach is a senior member of the DB Engineering team at Citadel and a recipient of multiple Microsoft Data Platform MVP awards between 2016 and 2022. He puts a high focus on performance tuning and automation at scale. He is also a frequent speaker at events like conferences and user groups.
Ajmer Dhariwal is a SQL Server consultant with more than two decades of experience in working for organizations ranging from small start-ups to global software vendors in industries ranging from banking to digital remarketing. Over this time, he has been involved with tuning everything from critical trading systems to clickstream processing applications. Based in St Albans, UK, when not technically reviewing books, he can be found spending his time reading and going for countryside walks.
Artur Wysoczanski works as a senior SQL DBA at Trainline in London, UK. He has spent the last 7 years of his career spanning over 20 years in IT specializing in SQL Server performance tuning and troubleshooting. On a daily basis, he works closely with development and operational teams to make sure that new and existing applications get the best possible database performance. His experience and good analytical skills allow him to help teams troubleshoot and understand problems arising on the company’s SQL server estate. He is also well skilled in other database technologies, such as Oracle, PostgreSQL, MySQL, and cloud-native technologies such as AWS Aurora MySQL and Aurora PostgreSQL, DynamoDB, and Amazon Keyspaces. He is a fan of the utilization of new cloud technologies in modern organizations.