Can Fill Factor be changed on specific tables without index rebuild?
5
votes
4
answers
3259
views
I've been digging around without any luck.
SQL Server 2008: Is it possible to adjust the fill factor on a specific clustered index/table without having to rebuild the entire table?
For example, if it has 400 million records, can we adjust the fill factor and have SQL Server use the new fill factor on all pages that haven't already exceeded that limit (as well as new splits), and then adjust pages that are over limit during index maintenance?
Is it possible to pre-define the fill-factor that an index should be built to during the next index maintenance?
Asked by Dave Sims
(333 rep)
Apr 27, 2017, 06:20 PM
Last activity: Oct 11, 2017, 01:53 AM
Last activity: Oct 11, 2017, 01:53 AM