Video description
- Discover how SQL Server optimizes a query and generates an execution plan
- Enable, read, and decipher execution plans for query analysis
- Identify a variety of common execution plan operators
- Use STATISTICS IO to gauge query impact on memory and disk resources
- Measure query duration using STATISTICS TIME
- Analyze problem queries to find the source of performance problems
- Identify common query mistakes and how to quickly resolve them
Table of contents
- Introduction 00:01:58
- What Does A Slow Query Look Like? 00:04:03
- How Is A Query Processed? 00:04:19
- Turning On and Using Query Execution Plans 00:07:53
- Enabling and Using STATISTICS IO 00:03:43
- About the Buffer Cache 00:04:07
- Enabling and Using STATISTICS TIME 00:03:12
- Identifying and Responding to Unwanted Table Scans 00:03:44
- Locating and Eliminating Implicit Conversions 00:03:34
- OR in Filters and Joins 00:03:35
- Functions in Filters and Joins 00:04:16
- Recap 00:04:06
Product information
- Title: Introduction to SQL Server Query Optimization: Understanding Query Optimization and Built-in Optimization Tools
- Author(s):
- Release date: June 2019
- Publisher(s): Apress
- ISBN: 9781484251447
You might also like
book
SQL Server Query Tuning and Optimization
Get well-versed with ready-to-use techniques for creating high-performance queries and applications Key Features Speed up queries …
book
SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and …
book
SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under …
book
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
Write optimized queries. This book helps you write queries that perform fast and deliver results on …