Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Carolyn Richardson What do you do with a new SQL Server? RE: What do you do with a new SQL Server?

  • June 12, 2008 at 6:26 am

    #827785

    AndyD (6/12/2008)

    Yes, I agree, good concise advice.

    Just one quick question - you mention the Fill Factor defaults to 100% in 2005, whereas it was 90% in 2000. [To be precise, it defaults to zero, which is the same as 100%]

    Would you suggest changing the default Fill Factor to 90%? Or to some other value? Or leave the system-wide default and change the fill factor on a per-index basis?

    Andy

    I remember seeing an article on the difference between 0% and 100% fill factors... Dunno if I can find it, again, but I'll look...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)