SELECT TOP 25 A.name,(SELECT rows FROM dbo.sysindexes s WITH (NOLOCK)

WHERE s.indid < 2 AND s.id = A.ID )AS [Row count],SpaceUsedMB from

(SELECTSO.NAME,SO.ID,

CONVERT(numeric(15,2),(((CONVERT(numeric(15,2),SUM(i.reserved)) * (SELECT low

FROM master.dbo.spt_values WITH (NOLOCK) WHERE number = 1 AND type = 'E')) / 1024.)/1024.)) SpaceUsedMB

FROMdbo.sysindexes i WITH (NOLOCK) INNER JOIN dbo.sysobjects so WITH (NOLOCK)

ON i.id = so.id AND so.type IN ('U')

WHEREindid IN (0, 1, 255)

GROUP BY SO.NAME,SO.ID)

AS A

ORDER BY SpaceUsedMB DESC

Just one of the many uses of spt_values