CODEWITHSUNDEEP
sql-serverfillfactor
Karthi
Karthi

Reputation: 708

Fill Factor for Datawarehouse - SQL Server

I am planning to set up a script to rebuild all the indexes in one particular database. How do I set the fill factor? How do I determine the fill factor here.

My database is used for data-warehouse purpose. It is insert/update heavy system. Could some suggest me which is the good fill factor rate and how do I know if this fill factor is right.

I am using SQL Server 2008 database.

Upvotes: 1

Views: 871

Answers (1)

benjamin moskovits
benjamin moskovits

Reputation: 5458

You want a fillfactor of 0 because you are probably loading the file once every period (every night, once a week). If you are going to do massive inserts/updates and you may find that its a lot quicker to drop all the indexes, load the table and recreate all the indexes. So if you are not going to add rows as they come in you want as few reads as possible when searching for something so you want your pages to be totally full. If you are doing inserts you want empty spaces on the page to avoid page splits and that is why you would set a fill factor of not 0.

Upvotes: 2

Related Questions