Post reply

Table - UnusedSize

  • September 30, 2010 at 3:58 am

    #97505

    Hi

    I checked one of the table its contain lot of unused free space as below details

    tablename - KW_5

    Row_Count - 24547

    ReservedSize - 392424 KB

    DataSize - 196384 KB

    IndexSize - 536 KB

    UnusedSize - 195504 KB

    This table looking like that unused size is 19 MB, so how would reclaim this size, Can someone please let me know.

    Thanks

  • September 30, 2010 at 9:05 am

    #1229685

    Please review the following article by Joe Webb

    http://weblogs.sqlteam.com/joew/archive/2008/01/14/60456.aspx

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • October 5, 2010 at 4:16 am

    #1231561

    Hi

    As per above URL, it is described DBCC cleantable command, It was worked whenever removed variable from table, this variable space only recliamed with dbcc cleantable command. so it does not work unused space from table.

    I tried dbcc cleantable ('dbname','tablename',0) for particular table, after that I really stucked because of unused size was increased , its not decresed.

    I followed steps as below

    1. DBCC DBREINDEX ('tablename')

    2. dbcc cleantable ('dbname','tablename',0)

    After that unused- size is 199360 KB

    thanks

  • October 6, 2010 at 8:58 am

    #1232665

    Is there a clustered key on this table. If there is then the dbcc dbreindex will free the space. If not, than nothing you do will re-org this table until there is a clustered index. You can search on b-tree vs. heap storage.

    Thanks

    Tom

Viewing 4 posts - 1 through 3 (of 3 total)

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