Is there a quick and easy way to list when each index in the database last updated statistics? The preferred answer would be a request. In addition, is it possible to determine the "quality" of statistics: FULLSCAN, SAMPLE n, etc.
EDIT
this worked for what I needed, a small mod for @OrbMan is a great answer ...
SELECT
STATS_DATE(i.object_id, i.index_id) AS LastStatisticsDate
,o.Name AS TableName
,i.name AS IndexName
FROM sys.objects o
INNER JOIN sys.indexes i ON o.object_id = i.object_id
WHERE o.is_ms_shipped=0
ORDER BY 1 DESC
source
share