Removing fill factors from Dev DB

  • How can I remove the fill factor settings for all of the tables that were created inadvertantly by the Optimazation Maintenance plan on my Dev PC? This is causing unnecessary inconsistencies when comparing our Dev to Production PC.

     

    TIA

    Dean

  • If you are using the Database Maintenance Plan Wizard, instead of using the Reorganize Pages with the Original Amount of Free Space option, choose the Change Free Space Per Page Percentage to option and specify the fill factor appropriated to you database design. If fill factor has to be different on different tables, recreate indexes (or rebuild) with fillfactor setting you need. This should be done manually.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply