Storing Pricing History

[yosiasz]

Elevating the DBA

There are no indices on the audit columns. What you're looking at is the clustered index. It's keyed on an "ever increasing" value and should never fragment. The fragmentation is cause by the "ExpAnsive" growth of the ModifiedBy column going from NULL to some value, which causes the row to no longer fit on the page, causing a page split, which is what is causing both the logical and rather nasty physical (page density) fragmentation that you're seeing in the chart. Of course, the clustered i…