Post reply

shrinking pages after atler column

  • August 4, 2003 at 12:24 am

    #160606

    Hi everyone,

    I have a massive table with a good number of smallint columns that are being used

    as booleans. I changed their type to bit in hopes of freeing up some space,

    but no matter what I do I can't get SQL Server to reclaim any of the unused space

    or even to use smaller pages for this table.

    Does anyone know how to do this, other than recreating the table and copying

    the data?

  • August 7, 2003 at 8:03 am

    #469001

    I would try to bcp the table out into a new table. Not 100%, but I remember reading that sql doesn't reclaim space in file when columns are shortned or dropped unless the table is dropped and recreated.

    Thanks Tom.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply