We explain query plan architecture and execution using an analogy of a home buyer, architect, builder, and supply store. We cover trivial query optimization, full optimization, and timeouts. Demo Scripts Transact-SQL /* Mastering Query Tuning – How SQL Server Builds Query Plans This script is from our Mastering Query Tuning class. To learn more: https://www.BrentOzar.com/go/masterqueries…
1.1 How SQL Server Builds Query Plans (42m)
We explain query plan architecture and execution using an analogy of a home buyer, architect, builder, and supply store. We cover trivial query optimization, full optimization, and timeouts. Demo Scripts Transact-SQL /* Mastering Query Tuning - How SQL Server Builds Query Plans This script is from our Mastering Query Tuning class. To learn more: https://www.BrentOzar.com/go/masterqueries...
To access this incredible, amazing content, you gotta get Live Class Season Pass or Mastering Query Tuning, or log in if you already shelled out the cash.
- 0.1 Prerequisites Before the Class (59 min)
- 0.2 How to Set Up Your Own Lab Server
- 0.4 The BE CREEPY Method (14m)
- 1.2 Cardinality Estimation (42m)
- 1.3 CTEs, Temp Tables, and APPLY (31m)
- 1.4 Lab 1: Improving Estimates (44m)
- 1.5 Using sp_BlitzCache to Find the Right (Wrong) Queries (43m)
- 1.6 Lab 2: Analyzing a Running Workload (63m)
- 2.1 Tuning for SELECT * and Lots of Rows (46m)
- 2.2 User-Defined Functions (34m)
- 2.3 Lab 3: Changing Results and Parameters (108m)
- 2.4 Dynamic SQL Pro Tips (43m)
- 2.5 Lab 4: Advanced Rewrites (72m)
- 3.1 Parameter Sniffing (85m)
- 3.2 Lab 5: Parameter Sniffing (90m)
- 3.3 Avoiding Deadlocks (31m)
- 3.4 SQL Server 2017 & 2019’s New Robots (13m)
- 4.1 Lab 6: The Final Setup (7m)
- 4.2 Lab 6: Index Tuning (33m)
- 4.3a Lab 6: usp_Q6627 (29m)
- 4.3b Lab 6: Logging sp_BlitzCache to a Table (5m)
- 4.3c Lab 6: usp_Q7521 (25m)
- 4.3d Lab 6: usp_Report3 (15m)
- 4.3e Lab 6: usp_FindRelatedPosts (24m)
- 4.3f Lab 6: usp_Q6627, Take 2 (34m)