August 2022
Intermediate to advanced
446 pages
11h 12m
English
Overview
In "SQL Server Query Tuning and Optimization", you will learn how to improve the performance of your SQL Server 2022 queries and applications by understanding query engine internals and adopting effective optimization techniques. This book combines practical knowledge with deep insights into query processing to help you achieve efficient and fast query execution.
What this Book will help me do
- Gain practical experience in using the Query Store to detect and address underperforming queries.
- Understand the workings of the SQL Server query optimizer and how it chooses execution plans.
- Learn how to use indexing strategies, such as columnstore indexes, to enhance query performance.
- Acquire skills to troubleshoot and fix issues related to cardinality estimation and plan caching.
- Master intelligent query processing features and apply them in real-world SQL Server applications.
Author(s)
Benjamin Nevarez is an experienced database professional renowned for his expertise in SQL Server performance tuning and optimization. With years of practical experience under his belt and a passion for helping others grasp complex technical concepts, Benjamin has authored several books on SQL Server and frequently speaks at technical conferences worldwide. His writing reflects a hands-on approach and includes real-world examples to make learning intuitive and effective.
Who is it for?
This book is ideal for SQL Server developers facing challenges with slow query execution and looking to enhance application performance. It is also suited for database administrators responsible for diagnosing and resolving performance issues. Database architects who design SQL Server applications for diverse workloads will find practical solutions. Whether you're looking to optimize existing queries or build high-performance applications, this book is for you.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.