SQL Server Performance

How to reclaim the spaces which the table allocate but unused

Discussion in 'Performance Tuning for DBAs' started by zhenyuanDeng, Nov 26, 2007.

  1. zhenyuanDeng New Member

    When i use the store procedure "sp_spaceused TableX", it will show me the messages like:
    name: TableX
    rows:34221
    reserved:30192 kb
    data:19552 kb
    index_size:10448 kb
    unused:1024000 kb
    How can i reclaim the unused space to the OS ?
  2. jagblue New Member

  3. zhenyuanDeng New Member

    Thanks jagblue
    I executed than command DBCC CLEANTABLE , but it did not work.
    May be the only method is moving the rows to another table, then trancate the table, and move the rows into it.

Share This Page