1
2
3
4
5
6
7
8
9
10
11
12
13
| SELECT
CONVERT (VARCHAR(30), MIN(o.name)) AS table_name ,
LTRIM(STR(SUM(reserved) * 8192.0 / 1024.0, 15, 0) + ' KB') AS table_size,
SUM(reserved) AS sum_reserved
FROM
sysindexes i, sysobjects o
WHERE
o.id = i.id
and i.indid IN (0, 1, 255) AND o.xtype = 'U'
GROUP BY
i.id
ORDER BY
sum_reserved desc
|