Database Reference
In-Depth Information
Figure 35-7.
Delta store and Delete bitmap: Delete bitmap page
It is worth noting that delta store uses page compression. As you will remember, SQL Server performs page
compression only when a page is full and retaining it only if the page compression provides significant space savings
as compared to row compression. Neither happened in our example; therefore, SQL Server kept row compression for
the data.
