Watch as we step through a real query, measure its performance, and iterate over improvements. You’ll see SQL Server 2016 & 2017’s new execution plan improvements, discover free community tools, and get valuable shortcuts. Part 1 (22 minutes): In Part 1, Brent explains the B.E. C.R.E.E.P.Y. process: Part 2 (41m): Brent shows you where to…
2.2 Queries: Watch Brent Tune Queries with SQL Server 2017 (106m)
Watch as we step through a real query, measure its performance, and iterate over improvements. You’ll see SQL Server 2016 & 2017’s new execution plan improvements, discover free community tools, and get valuable shortcuts. Part 1 (22 minutes): In Part 1, Brent explains the B.E. C.R.E.E.P.Y. process: Part 2 (41m): Brent shows you where to…
You'll need a membership to access this course. Check out my training classes.
- 0.1 Dec 27-29 Class Resources
- 1.1 Indexes: How to Think Like the Engine (110m)
- 1.2 Queries: How SQL Server Builds Plans and Cardinality Estimates (47m)
- 1.3 Indexes: How to Performance Tune Nonclustered Indexes with sp_BlitzIndex (70m)
- 1.4 Waits: LCK: Find and Fight Blocking (49m)
- 2.1 Queries: How to Identify and Fix Parameter Sniffing (84m)
- 2.3 Waits: CXPACKET – Parallelism Gone Wild (34m)
- 2.4 Waits: PAGEIOLATCH – Slow Storage (77m)
- 3.1 Processes: How to Triage Performance Emergencies (84m)
- 3.2 Waits: ASYNC_NETWORK_IO, RESOURCE_SEMAPHORE, and WRITELOG (40m)
- 3.3 DBA: Corruption 201 – Optimizing CHECKDB Performance (43m)