Video description
Begin your journey into query optimization by learning the basics of how SQL Server processes a query from start to finish. Once this foundation is established, you will focus on execution plans: What are they? How do we read them? And what are their more common operations? A variety of statistics options will be introduced that provide insight into query duration and the load that a given query presents on memory and storage resources.
With a set of tools defined, you will tackle a variety of common optimization challenges. You’ll review some common problems in which performance is inadequate and then solutions to mitigate those problems and improve performance. These basic patterns will provide a format for viewing and analyzing queries with the goal of being able to identify the source of the problem when a query is running too slow.
What You'll Learn
- 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
Who This Video Is For
Database administrators, developers, or anyone who writes TSQL queries on a regular basis. For all database professionals who need to write efficient code that executes quickly while consuming minimal resources.
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
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 …
book
MySQL 8 Query Performance Tuning: A Systematic Method for Improving Execution Speeds
Identify, analyze, and improve poorly performing queries that damage user experience and lead to lost revenue …
book
Effective SQL: 61 Specific Ways to Write Better SQL, First Edition
“Given the authors’ reputations, I expected to be impressed. I was blown away! . . . …
