Results 1 to 4 of 4

Thread: Fill Factor

  1. #1
    Join Date
    Oct 2003
    Posts
    83

    Question Unanswered: Fill Factor

    If fill factor is specified as 100 for a table what will be the impact of this?I want to know any updation or insertion will be possible or not?

  2. #2
    Join Date
    Jan 2005
    Location
    TempDb
    Posts
    228
    SQL BOL - The FillFactor property exposes the percent of each page used to store index data when the index is created. Note: this only applies at the time the index is created - SQL Server doesn't try to maintain the FillFactor: it is just a starting point.

    With FillFactor = 100, you are requesting your index pages to be 100% full when the index is created. You will be able to insert/update, but the likelihood of a page split is related to the fillfactor - the higher the FillFactor, the more likely SQL Server will have to split the page. Thus, if you have heavy changes, SQL Server will have to split index pages more frequently.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Just to add to it, - only if inserted/updated data fits in the middle of an existing page.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    a fill factor of 100 is essentially a fill factor of 0 or not issuing the fill factor statement at all.
    check out books online {Fill Factor}

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •