When you look at the arrows on an actual plan, what do the arrow sizes mean? When you see the list of wait stats, they’re accurate, right? Buckle up and prepare to be disappointed – a lot of what you see in a query plan just flat out isn’t true. Here is the demo script:…
07 – Execution Plans are Lying Liars (24m)
When you look at the arrows on an actual plan, what do the arrow sizes mean? When you see the list of wait stats, they’re accurate, right? Buckle up and prepare to be disappointed – a lot of what you see in a query plan just flat out isn’t true. Here is the demo script:...
To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.
- 01 – How NOLOCK Can Show Incorrect Results (10m)
- 02 – Locking and Blocking (29m)
- 03 – Deadlocks (18m)
- 04 – Trivial Plans (17m)
- 05 – Picking Index Key Order (34m)
- 06 – Missing Index Column Order (21m)
- 08 – Estimates vs Actuals (48m)
- 09 – Table Variables vs Temp Tables: The 2019 Rematch (10m)
- 10 – How Plans Are Cached (10m)
- 11 – Parameter Sniffing (19m)
- 12 – The Problem with Multi-Parameter Stored Procedures (21m)
- 13 – Dynamic SQL Pro Tips (34m)
- 14 – Parallelism (38m)
- 15 – Simplification (14m)
- 16 – Filtered Indexes (23m)
- 17 – Indexed Views (22m)
- 18 – Computed Columns (14m)
- 19 – Heaps of Sadness (11m)
- 20 – Index Usage DMVs are Lying Liars (26m)
- 21 – Resource Semaphore (37m)
- 22 – Questions (17m)
- Bonus – Building a Fork Bomb in T-SQL (11m)
- Bonus – Managed Instance DTUs (4m)
- Bonus – Memory Usage by Different Operators (15m)
- Bonus: Numbers Tables (18m)