Do you want to find out when statistics have been updated?
Posted
by simonsabin
on SQL Blogcasts
See other posts from SQL Blogcasts
or by simonsabin
Published on Tue, 30 Nov 2010 11:14:03 GMT
Indexed on
2010/12/06
16:58 UTC
Read the original article
Hit count: 145
Filed under:
If you need to find out when statistics were last updated run the following select OBJECT_NAME ( s . object_id ) object , s . name , STATS_DATE ( s . object_id , s . stats_id ) StatsDate , s . auto_created , s . filter_definition , s . has_filter , s . no_recompute , s . user_created , stuff (( select ',' + col . name from sys . stats_columns sc join sys...(read more)
© SQL Blogcasts or respective owner
