Session

A heap of trouble: the hidden costs of heaps in SQL Server

About heaps in SQL Server.
What they are, when to use them, and how using them in the wrong ways and places can negatively impact query performance, inserts, updates, and even lead to silently applying the wrong compression to newly inserted data.

Attendees will learn:
1. When heaps are actually useful
2. When heaps end up causing more harm than good
3. How to spot the issues
4. How to correct them

Note: I'm marking this as Intermediate because I believe all devs should be aware of these things, but I will be using DBCC PAGE a couple of times.

Vlad Drumea

Principal Database Analysis & Development Administrator

Cluj-Napoca, Romania

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top