Post reply

All Fill Factors that Differ From the Default

  • October 7, 2011 at 9:34 am

    #244965

    Hi All

    Words of wisdom please.. is it possible via script to identify all indexes for a database that have a fill factor other then the default ?

    thanks simon

  • October 7, 2011 at 9:41 am

    #1391842

    select * from sys.indexes where fill_factor<>0 -- assumption - default fill factor is 0

    I have assumed the default fill_factor setting has not been checked. Run the below code to check the default fill_factor.If it has not been changed, it should be 0.

    sp_configure 'fill factor'

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

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