Link to home
Start Free TrialLog in
Avatar of ChrisCouture
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.

Avatar of ispaleny
ispaleny
Flag of Czechia image

Yes.
ASKER CERTIFIED SOLUTION
Avatar of higginspi
higginspi

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of higginspi
higginspi

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.