Home Forums SQL Server 2008 SQL Server 2008 Administration Faster way to release the Unused Space back to Disk RE: Faster way to release the Unused Space back to Disk

  • January 2, 2013 at 3:53 pm

    #1573111

    I have 2 quick questions on Data file size usage behavior

    1) I see that Indexes have heavy fragmentation levels: This effects the DML Performance for sure, but will this allow the data file size to grow extra than actual consumed space?

    2) Will adding few indexes at appropriate places reduce the Data file to not pre capture so much disk space than actual consumed space.?