SQL Server - Estudio volumétrico de tablas Sql Server

-- Numero de registros por tabla, todas las bases

EXECUTE master.sys.sp_MSforeachdb 'USE [?];

IF      ''?''     NOT IN (''master'',''model'',''msdb'', ''tempdb'')

BEGIN

SELECT db_name() as [Database Name], object_name(id) as [Table], rowcnt as [Total Rows]

FROM sys.sysindexes

WHERE indid = 1

AND rowcnt > 0

ORDER BY 3 DESC

END'

-- Obtiene el peso de las tablas en MB

select Name

  ,(select top 1 row_count from sys.dm_db_partition_stats where object_id=s.object_id) as rows

  ,Modify_date

  ,(select  convert(decimal(8,2),(SUM ( CASE

WHEN (index_id < 2) THEN (in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count)

ELSE lob_used_page_count + row_overflow_used_page_count

END

)*0.0078125 ))

FROM sys.dm_db_partition_stats

WHERE object_id = s.object_id) as [Table weight MB]

from sys.tables s

where type_desc = 'USER_TABLE'

order by [Table weight MB] desc