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

SELECT SCHEMA_NAME(C.SCHEMA_ID) ESQUEMA, 
       OBJECT_NAME(A.OBJECT_ID) TABELA, A.NAME COLUNA, B.NAME TIPO, 
       CASE WHEN B.NAME = 'IMAGE' THEN 'VARBINARY(MAX)' 
            WHEN B.NAME = 'NTEXT' THEN 'NVARCHAR(MAX)'
            WHEN B.NAME = 'TEXT' THEN 'VARCHAR(MAX)'
       END NOVOTIPO,
       CASE WHEN B.IS_NULLABLE = 0 THEN 'NOT NULL' ELSE '' END PERMITENULO
FROM SYS.COLUMNS A JOIN SYS.TYPES B 
       ON A.SYSTEM_TYPE_ID = B.SYSTEM_TYPE_ID
     JOIN SYS.TABLES C ON C.OBJECT_ID = A.OBJECT_ID
          AND SCHEMA_NAME(C.SCHEMA_ID) IN= ('DBO','TOTVSAUDIT')             
          AND OBJECT_NAME(A.OBJECT_ID) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI IN ( SELECT TABELA COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI FROM GDIC (NOLOCK))
          AND B.NAME IN  ('TEXT', 'NTEXT', 'IMAGE') 
ORDER BY OBJECT_NAME(A.OBJECT_ID), A.NAME