Post reply

Default fillfactor kept by SQL Server when it is rebuilding the indexes.

  • November 21, 2012 at 9:01 pm

    #393644

    Hi,

    When we want to do performance tuning we usually rebuild the indexes. When SQL Server is rebuilding this indexes it rebuilds it by keeping some value for fill factor(know as default value for fill factor). So i would like to know what is the default FillFactor value for that rebuild indexes.

  • November 21, 2012 at 10:38 pm

    #1561466

    Shadab Shah (11/21/2012)

    Hi,

    When we want to do performance tuning we usually rebuild the indexes. When SQL Server is rebuilding this indexes it rebuilds it by keeping some value for fill factor(know as default value for fill factor). So i would like to know what is the default FillFactor value for that rebuild indexes.

    If no one made a change to the default, the default is "0" which is technically the same as "100"... in other words, no empty space in the tables after an index is rebuilt except for a single partial row size.

    --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)

  • November 21, 2012 at 10:41 pm

    #1561470

    Gah... I have to add to that. When you first create an index and you don't specify a FILL FACTOR during creation, it will use the default that I previously mentioned.

    When you rebuild indexes and don't specify a FILL FACTOR, it will use whatever FILL FACTOR the index was assigned during creation. If you specify a new FILL FACTOR during the rebuld, that's the one that will be used.

    --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)

  • November 21, 2012 at 10:51 pm

    #1561478

    Thanks jeff that was helpfull

  • November 21, 2012 at 11:05 pm

    #1561484

    You bet. Thank you for the feedback.

    --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)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply