ChrisCouture
asked on
Fill Factor
How do you remove fill factor from the entire database besides going to all of the indexes and removing manually. Is there an automatic way.
Yes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The selection of tables is from the database you are in, not for the whole server.
And this process may take a *very* long time if you have millions of rows, and depending on your server maybe even a long time if you have tens or hundreds of thousands. Also depends on how many indexes you have, etc.