Post reply

Fillfactor and amount of storage space required

  • November 30, 2005 at 11:03 am

    #92320

    Could you please explain the following statement:

    Creating a clustered index with a FILLFACTOR affects the amount of storage space the data occupies because SQL Server redistributes the data when it creates the clustered index.

    I was under the impression that the amount of storage space the data occupies would be affected because the storage space required would depend upon the amount the data needs and the amount of free space required to be left in each leaf page. But the other half of the statement explains some different reason for why the amount of storage space would be affected. Could you please shed some light on this? Thank you very much.

  • December 1, 2005 at 6:38 am

    #607017

    I don't think there is some basic difference in what you say and what the other half of the statement says. "SQL Server redistributes the data when it creates the clustered index" means, that data are redistributed over the pages to fit the required fill ratio (in other words, data are being moved so that the amount of free space on each page corresponds to this setting).

  • December 2, 2005 at 9:38 am

    #607428

    Thanks Vladan. I do get your point.

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

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