Skip to Content
0
Jan 20, 2012 at 09:55 AM

How to reduce size of SQL server table?

126 Views

Hi experts,

I have a table with 99.9% of unused size(9GB). How do I reduce the size?

I have tried those commands below but they do not work.

ALTER INDEX [VBDATA~0] ON qa2.VBDATA REBUILD

DBCC CLEANTABLE (QA2,"qa2.VBDATA", 0)

WITH NO_INFOMSGS;

GO

ALTER INDEX ALL ON qa2.VBDATA REBUILD