DB動則幾十G,百G,,,,,,,瘦身前先了解一下Table筆數SELECT COUNT(*) AS [Total] FROM [TableName]Table資料大小sp_spaceused TableName針對DB所有TABLE大小在所在DB下,Query,,,,,?保留EXEC sp_MsForEachTable "Sp_SpaceUsed '?'"資料表的筆數sp_MsForEachTable 'SELECT ''?'', COUNT(*) FROM ?' 列出全部的資料庫sp_MSforeachdb 'SELECT ''?'''