How to remove fill factor (reset to 0%) all DB | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to remove fill factor (reset to 0%) all DB

Hi, I created a maintenance task which optimize the indexes weekly and leave 10% free space. Asa result, all indexes now have a 90% fill factor. I would like to set the fill factor to 0% so that I can compare the DB table scripts with an older version where the fill factor was 0%. I’ve tried DBCC DBREINDEX but the value 0 is ignored. Is there faster anyway than manual to reset the fill factor of all indexes and PK to 0% Thanks in advance.
You can still compare the scripts, by removing the fill factor from both scripts – it’s just text, as long as you don’t run it.
Yes of course. I was just wondering if there is a way to set Fill Factor to 0%. It just seems weird that an option cannot be undone.
Are you having any disk space issues? Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.