Last post Mar 01, 2012 12:33 AM by Decker Dong - MSFT
Feb 28, 2012 06:44 AM|prathika|LINK
In sqlserver Database Table we have 1,00,000 rows.When we delete all rows the size of the table is decreased or not???
If we want to decrease the size of the table is there any way to synchronize table size or any other ways??
Please give your sugessions
Feb 28, 2012 06:47 AM|vinay13mar|LINK
check the link
Mar 01, 2012 12:33 AM|decker dong - msft|LINK
1）For deleting all the records，plz use
truncate table xxx instead of delete from xxx，which is fast and easy。
2）For compressing the specific tables to minimize the size as much as possible，I think you can have a try this：
3）As for Access，I think you can use the Compress tool after deleting all the records：