최근 통계 일자 DMV


http://basitaalishan.com/2013/04/15/determining-when-statistics-were-last-updated-in-sql-server/
http://technet.microsoft.com/ko-kr/library/ms177623.aspx
http://sqlblog.com/blogs/kalen_delaney/archive/2013/04/09/more-statistics-info.aspx 

SQL2012 버젼 이후부터 sys.dm_db_stats_properties 추가되었다.  이전 버젼은 STATS_DATE 함수로 사용해야 한다. 


SELECT 
	object_id
	, OBJECT_NAME(object_id) AS [ObjectName]
	, [name] AS [StatisticName]
	, STATS_DATE([object_id], [stats_id]) AS [StatisticUpdateDate]
FROM sys.stats
WHERE object_id > 100
ORDER BY STATS_DATE([object_id], [stats_id]) DESC