• Gullimeel (7/9/2012)


    Just a small thing.Why do you have a fill factor of 80 for increasing identity field?Shouldnt it be 100%?

    I agree that the fillfactor should be carefully reviewed, but not that it's a "small thing". It could have a big impact on performance if/when you rebuild the table.

    Unless you do significant increases to the row length after it is inserted, you need to increase the fillfactor considerably. [Even if that is true, I would instead consider "pre-padding" the row rather than using such a low fill factor.]

    For a table this large, I usually aim for ~98%, since you typically have to allow for varchar columns to be lengthened on occasion.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.