Well, that multi-parameter search stored procedure was a complete performance disaster. We need a better way to handle diverse input parameters – and that’s where dynamic SQL comes in. We’ll show you several pro tips for better troubleshooting and performance. Demo code: Transact-SQL /* Dynamic SQL – Building, Tuning, and Testing It Better v1.91 -…
13 – Dynamic SQL Pro Tips (34m)
Well, that multi-parameter search stored procedure was a complete performance disaster. We need a better way to handle diverse input parameters – and that’s where dynamic SQL comes in. We’ll show you several pro tips for better troubleshooting and performance. Demo code: Transact-SQL /* Dynamic SQL – Building, Tuning, and Testing It Better v1.91 -…
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)
- 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)