In this demo, you’ll learn why index key order doesn’t matter much for equality searches, but does for INequality searches, and why SQL Server may sort on fields even though they’re in your index. [wpc_complete] Transact-SQL /* Picking Index Key Order v1.2 2019-05-24 Here’s what you’re going to learn in this demo: * Index key…
05 – Picking Index Key Order (34m)
In this demo, you’ll learn why index key order doesn’t matter much for equality searches, but does for INequality searches, and why SQL Server may sort on fields even though they’re in your index. [wpc_complete] Transact-SQL /* Picking Index Key Order v1.2 2019-05-24 Here's what you're going to learn in this demo: * Index key...
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)
- 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 – Building a Fork Bomb in T-SQL (11m)
- Bonus – Managed Instance DTUs (4m)
- Bonus – Memory Usage by Different Operators (15m)
- Bonus: Numbers Tables (18m)