sql server 通过一句话就能统计处表的大小，语句再查询分析器下运行

select object_name(id) tablename,8*reserved/1024 reserved,rtrim(8*dpages/1024)+'Mb' used
,8*(reserved-dpages)/1024 unused,8*dpages/1024-rows/1024*minlen/1024 free,
rows,* from sysindexes
where indid=1
order by reserved desc

转载%77%77%77请%2E%66%6F%72%61%73%70%2E%63%6E注明