Vlad Drumea
Principal Database Analysis & Development Administrator
Cluj-Napoca, Romania
Actions
Vlad Drumea is an accomplished SQL Server DBA, Data Platform MVP and MCSE, with over 14 years of experience. With most of his experience being gained in large production environments.
His expertise lies in query performance optimization, database security, and automation.
Beyond being a SQL Server DBA, he’s passionate about information security and holds certifications such as OSCP (Offensive Security Certified Professional) and PNPT (Practical Network Penetration Tester).
Badges
Area of Expertise
Topics
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.
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