Home Forums SQL Server 2014 Administration - SQL Server 2014 Reducing Index Fragmentaion during Inserts RE: Reducing Index Fragmentaion during Inserts
Jason A. Long
SSC-Insane
Points: 23780
More actions
April 26, 2015 at 2:20 pm
#1793543
Lowering the fill factor on your index(es) may help as well. Lowering the fill factor will create more pages but it can certainly help reduce (or prevent) fragmentation when you have a lot of non-sequential inserts.
What is the current fill factor?