1. 保留需要的数据之新表中->TRUNCATE原表数据->还原之前保留的数据之原表中->压缩表空间
脚本类似如下
SELECT * INTO #keep FROM Original WHERE CreateDate > '2011-12-31' TRUNCATE TABLE Original INSERT Original SELECT * FROM #keep
DROP TABLE #keep
压缩表空间
DBCC SHRINKDATABASE(DB_NAME)
脚本类似如下
SELECT * INTO #keep FROM Original WHERE CreateDate > '2011-12-31' TRUNCATE TABLE Original INSERT Original SELECT * FROM #keep
DROP TABLE #keep
压缩表空间
DBCC SHRINKDATABASE(DB_NAME)
转载于:https://www.cnblogs.com/fire_to_fire/p/7418084.html