Histórico da Página

with cte_sizes AS (
    SELECT p.OBJECT_ID, OBJECT_NAME(p.OBJECT_ID) AS NOME,
        CAST((SUM(a.total_pages) * 8.0) / 1024 AS DECIMAL(18,2)) AS TotalSizeMB
    FROM sys.partitions p JOIN sys.allocation_units a ON p.partition_id = a.container_id
    GROUP BY p.OBJECT_ID
),
cte_rows AS (
    SELECT OBJECT_ID, SUM(row_count) AS NumeroLinhas
    FROM sys.dm_db_partition_stats 
    WHERE index_id IN (0,1) GROUP BY OBJECT_ID
)

SELECT DISTINCT SCHEMA_NAME(c.schema_id) AS Esquema, OBJECT_NAME(a.object_id) AS Tabela, 
    d.TotalSizeMB AS Tamanho, ISNULL(r.NumeroLinhas, 0) AS Linhas
FROM sys.columns a 
JOIN sys.types b ON a.system_type_id = b.system_type_id 
    AND b.name IN (SELECT * FROM ( VALUES ('text'),('image')) tipos (nomes))
JOIN sys.tables c ON c.object_id = a.object_id 
    AND c.schema_id IN (SELECT * FROM ( VALUES (schema_id('dbo'))) esquemas (nomes))
JOIN cte_sizes d ON a.object_id = d.OBJECT_ID
LEFT JOIN cte_rows r ON a.object_id = r.OBJECT_ID
ORDER BY d.TotalSizeMB DESC