List statistics and date updated

The following query will list all the statistics in the current database, and the date they were lasted updated.

SELECT object_name(object_id) as tablename,

 name AS index_name,

 STATS_DATE(object_id, stats_id) AS statistics_update_date

FROM sys.stats

WHERE object_id > 1000

ORDER BY object_name(object_id), STATS_DATE(object_id, stats_id);

About Clay Lenhart

I am a DBA/Technical Architect for Latitude Group and love technology.
This entry was posted in SQL Server Administration. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>