4.7 Recap and Q&A (58m)
We summarize the most important lessons, explain how to ask questions via email, and take open questions from the audience. April 2017 class: January 2017 class:
You’ll need a membership to access this course. Check out my training classes.
We summarize the most important lessons, explain how to ask questions via email, and take open questions from the audience. April 2017 class: January 2017 class:
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.3 How to Think Like the Engine – Part 3 (46m)
- 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)