When was last statistics updated?

Here is the handy query that I use to find out last statistics update date for objects. Key to find statistics update date is function STATS_DATE which takes two arguments – object_id (id of table/indexed view) and stats_id (id of statistics object)

SELECT object_name(object_id) table_name
	,name index_name
	,CASE
		WHEN (is_unique | is_unique_constraint) = 1
			THEN 'UNIQUE-' + type_desc
		ELSE 'NON-UNIQUE-' + type_desc
		END type_desc
	,stats_date(object_id, index_id) last_stats_update_date
FROM sys.indexes ind
WHERE EXISTS (
		SELECT 1
		FROM sys.objects
		WHERE type = 'U'
			AND object_id = ind.object_id
		);

Further Reading:
STATS_DATE

Advertisement