## 查询各个表的记录数
select a.name, b.rows
from sysobjects a
inner join sysindexes b on a.id = b.id
where a.type = 'u'
and b.indid in (0, 1)
order by b.rows desc
## 截断一些无用的表,减小数据库体积大小
truncate table AutoRunnerRecords
truncate table informations
truncate table applicationlogs