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

  • December 21, 2012 at 1:34 am

    #1570781

    Mac1986 (12/21/2012)

    I have done the things that you have suggested but still in the next ETL run, again the Datafile size is boosted up and used space by the file is way less.

    Can you please suggest. What can be done now..

    If the space in the data file is used up and the file grows during ETL, then leave the data file alone, it needs to be the size it is.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass