Data-Driven Fill Factors

Tracy Boggiano has an Extended Event and a procedure to track page splits and then modify index-level fill factors accordingly:

So what is the solution?  Well it really depends.  But the solution I wrote walks you through

• Setting the default fill factor

• Tracking page splits

• Lowering the fill factor

Read on to learn more.