Video: .MP4, 1920x1080 30 fps | Audio: AAC, 48 kHz, 2ch | Duration: 48m
Genre: eLearning | Language: English + Subtitles | Size: 464 MB

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.
[i][/i]Screenshots