Home Forums SQL Server 2012 SQL 2012 - General Re-Indexed with the Wrong Fill Factor and Now All Databases Are Huge RE: Re-Indexed with the Wrong Fill Factor and Now All Databases Are Huge

  • Michael has good advice. I will amend it with a removal of the 90% fill factor recommendation. Many indexes in SQL Server can and should be 100% FF (or 95-100). Many others (GUIDs anyone?, partial-inserts-then-updated scenarios and some others) need to be 80-85% or even lower.

    In the best case, EVERY index in your system will have a fill factor set specifically for that index for specific reason(s).

    I do supposed if you can't do any research at all (like finding leading-column GUIDs) then 90% could be a decent middle-ground.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service