Home Forums SQL Server 2008 SQL Server 2008 - General Trying to understand non-clustered index Fragmentation RE: Trying to understand non-clustered index Fragmentation
LAW1143
SSCrazy
Points: 2743
More actions
January 22, 2013 at 12:15 pm
#1579784
for giggles, I rebuilt with a 50% fill factor:
avg_fragmentation_in_percent changed to 94.691...
Fragment_count up to 380190
avg_fragment_size_in_pages a touch over 1.03
and page_count is up (as expected) to 394577