mikaelsnavy
11/5/2015 - 4:50 PM

This is a collection of SQL scripts that will give you some information about your indexes.

This is a collection of SQL scripts that will give you some information about your indexes.

index_last_rebuilt.sql
content_copyfile_download
DECLARE @tableName VARCHAR(256);
SET @tableName = 'dbo.ct_pstor';

SELECT name AS Stats,
STATS_DATE(object_id, stats_id) AS LastStatsUpdate
FROM sys.stats
WHERE object_id = OBJECT_ID(@tableName)
and left(name,4)!='_WA_';