This is our last demo for a reason: we’re about to leave SQL Server in very bad shape. Transact-SQL /* Building a Fork Bomb in T-SQL v1.2 – 2019-06-06 Performance Tuning in 21 Demos: https://www.brentozar.com/go/21demos This demo requires: * Any supported version of SQL Server or Azure SQL DB with Agent job support *…
Bonus – Building a Fork Bomb in T-SQL (11m)
This is our last demo for a reason: we’re about to leave SQL Server in very bad shape. Transact-SQL /* Building a Fork Bomb in T-SQL v1.2 – 2019-06-06 Performance Tuning in 21 Demos: https://www.brentozar.com/go/21demos This demo requires: * Any supported version of SQL Server or Azure SQL DB with Agent job support *…
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)
- 07 – Execution Plans are Lying Liars (24m)
- 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 – Managed Instance DTUs (4m)
- Bonus – Memory Usage by Different Operators (15m)
- Bonus: Numbers Tables (18m)