Kalyan Kumar Akula's Blog : This Blog is about SQL Server
Sunday, April 18, 2010
Statistics update date
SELECT o.name AS Table_Name,i.name AS Index_Name,STATS_DATE(o.id,i.indid)
AS Date_Updated FROM sysobjects o JOIN sysindexes i ON i.id = o.id
WHERE xtype = 'U' AND i.name IS NOT NULL ORDER BY o.name ASC,i.name ASC
No comments: