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…
