SELECT objects.name AS object_name, indexes.name AS index_name,
STATS_DATE(indexes.OBJECT_ID, index_id) AS StatsUpdated
FROM sys.indexes
INNER JOIN sys.objects ON indexes.object_id = objects.object_id
--WHERE objects.OBJECT_ID = OBJECT_ID('dbo.yourtablename')
GO
Wednesday, April 6, 2011
[Maintenance] Checking age of statistics
Simple stuff, saved here in case anybody needs it
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment