MS SQL Server :: Fillfactor

Question About Fillfactor

Aug 19, 2005

Hello,

from what I gathered, if writes on table are more often than reads, then you should use a lower fillfactor - to reduce page splits (talking about clustered index here). But what if primary key = clustered index is incremental integer, and there NEVER is any insertion into middle/rename of rows, only appends, can I use 100% fill factor then?

thanks

View 3 Replies View Related

FillFactor Considerations

Apr 19, 2007

I have a table with about 200 million rows of data. I add a couple million rows of data each week to the table in a single load process. The table is used for reporting purposes only and there are never (not intentionally at least) any updates or deletes to the table. The data is always being added to the "end" of the table with the new AsOfDate being the main factor in the clustered index.

My question is this: Since I'm not "inserting" rows that would split pages, should I have my FILLFACTOR for the table set to 100, or am I missing something? I obviously want to save physical hard drive space, but I also don't want to slow down the import process.

BTW, I'm using SQL2000

View 1 Replies View Related

Alter Index FillFactor

Dec 5, 2007

If you perform an Alter Index All without the FillFactor (example below) and the previous fill factor for the table and it's index were (80%), will the fillfactor be set to the previous value (80) or the sql server default index fill factor value (0 or 100%)?

ALTER INDEX ALL ON [Sales Header] REBUILD
WITH (SORT_IN_TEMPDB=ON, STATISTICS_NORECOMPUTE=OFF)

Thanks,

Ian

View 3 Replies View Related

How To Remove WITH FILLFACTOR = 100 When Generate Sql Script ?

Jul 23, 2005

Hello,I'm using Entreprise Manager (for Sql Server 2000) to generate mydatabase's script. By mistake, i've changer FillFactor one time. And,now I can't remove this data from generated sql script. How to removethat ?Thank's a lot.

View 6 Replies View Related