The below query returns the statistics for a table last updated. It makes use of the sys.indexes and sys.tables catalog views, along with the STATS_DATE() function, to retrieve the date that each index was last updated for every user table in the current database.
SELECTt.name AS Table_Name, i.name AS Index_Name,i.type_desc AS Index_Type,dex_id) AS Date_Updated --,sp.rows --if you want tSTATS_DATE(i.object_id,i.i no know how many rows unrem this FROMject_id = i.object_id JOIN sys.partitions sp ON t.object_id = sp.sys.indexes i JOIN sys.tables t ON t.o bobject_id and i.index_id = sp.index_id --new WHERE i.type > 0 and --if you want to see heap rem thissp.rows > 0 ORDER BY t.name ASC, i.type_desc ASC, i.name ASC
This little query can be useful in troubleshooting and diagnosing performance-related issues. Sometimes, it's as simple as outdated statistics.