Home Forums SQL Server 2012 SQL 2012 - General Sum of data and index space used not equal to fileproperty() spaceused RE: Sum of data and index space used not equal to fileproperty() spaceused

  • Thanks mate. I was surprised too that it turns out to be fragmentation. A quick alter table rebuild cleared the excess reserved sp_spaceused. It's still the same number of rows.

    I used a batch size of 500 rows as anything higher seems to cause an issue with the older version of SSMA i'm stuck with.

    Before



    After