Home Forums SQL Server 2008 SQL Server Newbies Reduce database size RE: Reduce database size

  • December 5, 2012 at 5:25 am

    #1565691

    Bhuvnesh (12/5/2012)

    Lowell (12/4/2012)

    HEAP tables never release the space taken by deleted rows.

    this is new to me ..can you give me any article reference here ?

    sure!

    take a look at this recent thread, where someones HEAP was holding 15 gig, but the real data was only 600Meg

    http://www.sqlservercentral.com/Forums/Topic1390660-149-1.aspx

    and the same citation i posted in that link for ease of clicking:

    http://sqlserverpedia.com/wiki/Heaps#Deletes_and_Heaps

    Deletes and Heaps

    When data is deleted from a heap using a DELETE statement, SQL Server will not release the space; it remains allocated to the heap. This leads to space bloat that wastes valuable resources. To address this problem, you can do any of the following:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!