Take the 2-minute tour ×
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. It's 100% free, no registration required.

From technet I got the impression, that I either have to explicitly set the wanted fillfactor or when I do not specify it, the default fillfactor 0 is choosen.

For tables I know to get rows added fillfactor 0 isn't a good choice. Is there a way to rebuild an index, so that the last explicitly index is used ?

BTW: I think that that should be the default setting.

share|improve this question
add comment

1 Answer

When a new index is built is uses the default fill factor by default, unless a different fillfactor is specified.

When an index is rebuild it will use the same fill factor that was specified when the index was build or last rebuilt unless a different fillfactor is specified.

share|improve this answer
add comment

Your Answer

 
discard

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.