SQL Server: The size of each table in the statistics database

CREATE TABLE tmp (    name varchar (),    rowscount int,    reserved varchar (),      data varchar,    index _size varchar (+),    unused varchar ();  Insert TMP (name, Rowscount, reserved, data, index_size, unused) exec sp_msforeachtable @command1 = "sp_spaceused '?"; SELECT * FROM TMP where name <> ' tmp ' ORDER by namedrop table tmp;

A different approach

SELECT DISTINCT a.name, B.rowsfrom sysobjects A, sysindexes bwhere a.id = B.idand A.type = ' u ' and B.rows>0order by B.R oWS DESC

SQL Server: The size of each table in the statistics database