When you pass in a query, how does SQL Server build the results? We’ll role play: Brent Ozar will be an end user sending in queries, and you’ll be the SQL Server engine. Using simple spreadsheets as your tables, you’ll learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This…
1.3 How to Think Like the Engine – Part 3 (46m)
When you pass in a query, how does SQL Server build the results? We’ll role play: Brent Ozar will be an end user sending in queries, and you’ll be the SQL Server engine. Using simple spreadsheets as your tables, you’ll learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This…
You'll need a membership to access this course. Check out my training classes.
- 1.1 Skills Quiz – What’s Your Real Job Title (28m)
- 1.2 How to Think Like the Engine Part 1 (23m)
- 1.2 How to Think Like the Engine Part 2 (48m)
- 1.4 Heaps and Clustered Indexes (41m)
- 1.5 Tuning Indexes with sp_BlitzIndex Part 1 (47m)
- 1.5 Tuning Indexes with sp_BlitzIndex Part 2 (9m)
- 1.6 Homework: Index Tuning Workshop Part 1 (12m)
- 1.7 Homework: Index Tuning Workshop Part 2 – Answers (60m)
- 2.1 Building Execution Plans Part 1 (25m)
- 2.1 Building Execution Plans Part 2 (22m)
- 2.2 Parameter Sniffing Part 1 (20m)
- 2.2 Parameter Sniffing Part 2 (34m)
- 2.3 Watch Brent Tune Queries Part 1 (56m)
- 2.3 Watch Brent Tune Queries Part 2 (8m)
- 2.4 Common Problems in Query Plans (16m)
- 2.5 Functions (17m)
- 2.6 Designing Indexes for Queries Part 1 (21m)
- 2.6 Designing Indexes for Queries Part 2 (26m)
- 2.6 Designing Indexes for Queries Part 3 (14m)
- 2.7 Homework – Query Design Challenge (6m)
- 2.7 Homework – Query Design Challenge Answers (46m)
- 3.1 How to Measure Your Server – Part 1 (24m)
- 3.1 How to Measure Your Server – Part 2: Wait Stats (17m)
- 3.1 How to Measure Your Server – Part 3: sp_BlitzFirst and Monitoring Software (24m)
- 3.1 How to Measure Your Server – Part 4: Wait Stats Q&A (10m)
- 3.2 CXPACKET (41m)
- 3.3 PAGEIOLATCH: Slow Reads from the Data File (57m)
- 3.4 LCK – Locking Snapshot RCSI Part 1 (39m)
- 3.4 LCK – Locking Snapshot RCSI Part 2 (29m)
- 3.5 – CPU Waits – SOS_SCHEDULER_YIELD and THREADPOOL (44m)
- 3.6 – Hardware Waits – ASYNC_NETWORK_IO, RESOURCE_SEMAPHORE, and WRITELOG (25m)
- 4.1 Solving Waits with AlwaysOn Availability Groups (26m)
- 4.2 Solving Waits with Artisanal Indexes – Filters Views Computed Columns (32m)
- 4.3 Solving Waits with In-Memory OLTP (Hekaton) (43m)
- 4.4 VLDB Terabyteasaurus – Splitting Up Databases (33m)
- 4.5 How to Triage SQL Server Emergencies Part 1 (16m)
- 4.5 How to Triage SQL Server Emergencies Part 2 (44m)
- 4.5 How to Triage SQL Server Emergencies Part 3 (43m)
- 4.6 How to Write a Prescription (24m)
- 4.7 Recap and Q&A (58m)