Results 1 to 2 of 2

Thread: Fill factor

  1. 03-15-2001, 02:54 PM #1
    Quyen Guest

    Fill factor

    I have some tables and indexes to create in a new database. In the books online, it mentions that the server-wide default fill factor is the best choice in the majority of situations. But when I executed sp_configure, I realized that the default fill factor is 0. Should I keep using the default value or should I specify a new one ? Thanks.
    Reply With Quote Reply With Quote
  2. 03-15-2001, 09:04 PM #2
    Dale Shaw Guest

    Fill factor (reply)

    From memory, a 0 means 'fill all data pages but leave space free on index pages to add new records' or something like that.

    Fill factor only really affects tables with clustered indexes where you have a lot of insert activity. This is negated in most small-medium sites by a regular 'rebuild' done by Maintenance Wizard.


    Dale

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules