The series so far:
Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part 2 Optimizing Reads Heaps in SQL Server: Part 3 Nonclustered Indexes Heaps in SQL Server: Part 4 PFS contention
After looking at the internal structures and the selection of data in heaps in the previous articles, the next articles will describe how DML operations can be optimized on a heap.
Demo set up
I use data from a demo database for all demos for demonstration purposes in articles and conferences. You can download the database [CustomerOrders] here.
In this article, I’ll use an