19 – Heaps of Sadness (11m)

Heaps are what you get when someone doesn’t even care enough about their data to configure a clustered index. Heaps are vulnerable to two big performance issues: deletes don’t, and updates can cause forwarded fetches. Learn the performance impact in this demo: Demo script: Transact-SQL /* Heaps Of Sadness v1.1 – 2019-04-09 Performance Tuning in…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.