Home Forums SQL Server 2008 SQL Server 2008 High Availability Delete massive records and still can't shrink db RE: Delete massive records and still can't shrink db

  • October 25, 2016 at 12:14 am

    #1908508

    WhiteLotus (10/24/2016)

    Thanks for the reply . Much appreciated

    No message because when I right click on that db and choose Shrink -> data file . It shows up a shrink file dialog box telling me that available free space is 0 % .

    So that’s why I can’t shrink at all ?

    After you did your massive delete, which does NOT compress partially full pages, did you rebuild the indexes (all of them) on the tables you did the deletes on? If the table has blobs in it, you'll need to do a reorganize the indexes that include those blobs (which will also include the clustered index).

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)