by Ed Pollack | Released June 2019 | ISBN: 9781484251447

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 LearnDiscover how SQL Server optimizes a query and generates an execution planEnable, read, and decipher execution plans for query analysisIdentify a variety of common execution plan operatorsUse STATISTICS IO to gauge query impact on memory and disk resourcesMeasure query duration using STATISTICS TIME Analyze problem queries to find the source of performance problemsIdentify common query mistakes and how to quickly resolve themWho This Video Is ForDatabase 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. Show and hide more

1. Introduction 00:01:58
2. What Does A Slow Query Look Like? 00:04:03
3. How Is A Query Processed? 00:04:19
4. Turning On and Using Query Execution Plans 00:07:53
5. Enabling and Using STATISTICS IO 00:03:43
6. About the Buffer Cache 00:04:07
7. Enabling and Using STATISTICS TIME 00:03:12
8. Identifying and Responding to Unwanted Table Scans 00:03:44
9. Locating and Eliminating Implicit Conversions 00:03:34
10. OR in Filters and Joins 00:03:35
11. Functions in Filters and Joins 00:04:16
12. Recap 00:04:06
Show and hide more