Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using a COTS package to perform index rebuilds across my SQL Server portfolio. The package unfortunately doesn't have an option to set index fill factors globally for an individual instance or DB (I can set them when scheduling rebuilds on an index-by-index basis, but with 1,600+ indexes, I'd like to set them in advance in bulk). Outside of an ALTER INDEX command, is there a way I can redefine existing index fill factors?

share|improve this question
Maybe the package doesn't have an option for that because it's not necessarily a good idea.... – Jon Seigel Apr 9 '13 at 16:37

Check your DB Server (or instance) options, it will set every index based on the fill factor you specified.

sp_configure 'show advanced options', 1
sp_configure 'fill factor', x --set the fill factor value here, such as 70 for 70%
sp_configure 'show advanced options', 0


Do note, it will not actually rebuild or alter existing indexes. It will fulfill your request that all future index rebuilds will now have this fill factor, unless specified in the rebuild index command. Anything specified in the rebuild command will override this option.

share|improve this answer
Note this is an instance option, not a database option. – Jon Seigel Apr 9 '13 at 16:35
Good point. I used the wrong word, updating. Thanks. – Ali Razeghi Apr 9 '13 at 19:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.