La siguiente consulta permite usando una conexión DAC (Dedicated Administrator Connection), obtener los cambios que ha sufrido la primera columna de una estadística y estimar cuando esta caduca.
SELECT obj.name
, stat.name
— StatCol.stats_column_id
, COL_NAME(StatCol.object_id, StatCol.column_id) AS column_name
, RowSet.rcrows
, SetCol.rcmodified
FROM sys.objects Obj
INNER JOIN sys.stats AS Stat
ON Stat.object_id = Obj.object_id
INNER JOIN sys.stats_columns AS StatCol
ON Stat.object_id=StatCol.object_id
AND Stat.stats_id = StatCol.stats_id
INNER JOIN sys.sysrowsets AS RowSet
ON RowSet.idmajor=Stat.object_id
AND RowSet.idminor=Stat.stats_id
INNER JOIN sys.sysrscols SetCol
ON SetCol.rsid = RowSet.rowsetID
AND SetCol.OrdKey=StatCol.stats_column_id
WHERE OBJ.is_ms_shipped=0
AND StatCol.stats_column_id=1
