12
May
May
select name,SIZE = sum(reserved) * CONVERT(FLOAT, (SELECT LOW FROM MASTER.DBO.SPT_VALUES WHERE NUMBER = 1 AND TYPE = ‘E’)) /1024.00/1024.00
from sysindexes
where indid in (0,1,255)
GROUP BY name
ORDER BY SIZE DESC
This entry was posted
on Monday, May 12th, 2008 at 2:07 am and is filed under 工作手记.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or TrackBack URI from your own site.