Find last statistics update date

Find below 2 ways to find the last statistics update on a SQL table,

1. Using STATS_DATE Function,

SELECT name AS index_name,

STATS_DATE(object_id, index_id) AS statistics_update_date

FROM sys.indexes

WHERE object_id = OBJECT_ID('tblname');

Ref:- http://msdn.microsoft.com/en-us/library/ms190330.aspx

2. Use SHOW_STATISTICS consistency checker.

 DBCC SHOW_STATISTICS ('tblname', indexname);

Ref:- http://msdn.microsoft.com/en-us/library/ms174384.aspx