Untitled

 avatar
user_6688396
plain_text
2 years ago
836 B
5
Indexable
SELECT

  SUM(EspacoTotalKB) AS TOTAL
FROM(

SELECT
    t.NAME AS Entidade,
    p.rows AS Registros,
    SUM(a.total_pages) * 8 AS EspacoTotalKB,
    SUM(a.used_pages) * 8 AS EspacoUsadoKB,
    (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS EspacoNaoUsadoKB
FROM
    sys.tables t

INNER JOIN sys.indexes i
ON t.OBJECT_ID = i.object_id

INNER JOIN sys.partitions p
ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id

INNER JOIN sys.allocation_units a
ON p.partition_id = a.container_id

LEFT OUTER JOIN sys.schemas s
ON t.schema_id = s.schema_id

WHERE t.NAME NOT LIKE 'dt%'
AND t.is_ms_shipped = 0
AND i.OBJECT_ID > 255
AND t.NAME NOT IN('oce_forms_logs', 'oce_forms_logs_data', 'oce_forms_retirement_columns')

GROUP BY 
  t.Name,
  s.Name,
  p.Rows

--ORDER BY
  --  Registros DESC
) FOO
Editor is loading...