SQL-скрипт для определения размера таблиц

DECLARE @pagesizeKB INT
SELECT @pagesizeKB = low / 1024
FROM master.dbo.spt_values
WHERE NUMBER = 1 AND TYPE = 'E'

SELECT
  TABLE_NAME = OBJECT_NAME(o.id),
  ROWS = i1.rowcnt,
  reservedMB = (ISNULL(SUM(i1.reserved), 0) + ISNULL(SUM(i2.reserved), 0)) * @pagesizeKB/1024,

  dataMB = (ISNULL(SUM(i1.dpages), 0) + ISNULL(SUM(i2.used), 0)) * @pagesizeKB/1024,

  index_sizeMB = ((ISNULL(SUM(i1.used), 0) + ISNULL(SUM(i2.used), 0))
    - (ISNULL(SUM(i1.dpages), 0) + ISNULL(SUM(i2.used), 0))) * @pagesizeKB/1024,

  unusedMB = ((ISNULL(SUM(i1.reserved), 0) + ISNULL(SUM(i2.reserved), 0))
    - (ISNULL(SUM(i1.used), 0) + ISNULL(SUM(i2.used), 0))) * @pagesizeKB/1024

FROM sysobjects o
    LEFT OUTER JOIN sysindexes i1
    ON i1.id = o.id AND i1.indid < 2

    LEFT OUTER JOIN sysindexes i2
    ON i2.id = o.id AND i2.indid = 255

WHERE OBJECTPROPERTY(o.id, N'IsUserTable') = 1 --same as: o.xtype = 'IsView'
OR (OBJECTPROPERTY(o.id, N'IsView') = 1 AND OBJECTPROPERTY(o.id, N'IsIndexed') = 1)

GROUP BY o.id, i1.rowcnt

ORDER BY
    --(ISNULL(SUM(i1.dpages), 0) + ISNULL(SUM(i2.used), 0)) * @pagesizeKB desc --3 DESC
    --i1.rowcnt desc
    dataMB DESC