Tuesday, February 1, 2011

Statistics last updated date

To find out the last updated date of all statistics, you can use the below query:

select name,stats_date(object_id, index_id) from sys.indexes

No comments:

Post a Comment