sql server统计表大小
经验与学习 2011/1/4 14:10:23 点击:不统计
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注明