TSQL to get an index age in a database

Published 06 September 07 06:37 AM | SQL Master 
SELECT 
            ‘Index Name’ = ind.name,
            ‘Statistics Date’ = STATS_DATE(ind.object_id, ind.index_id)
FROM
            SYS.INDEXES ind
WHERE
            OBJECT_NAME(ind.object_id) = ‘Table_Name’
Filed under: , , ,

Comments

# Other SQL Server Blogs around the Web said on September 6, 2007 7:09 AM:

SELECT ‘Index Name’ = ind . name , ‘Statistics Date’ = STATS_DATE ( ind . object_id , ind . index_id

# SSQA.net - SqlServer-QA.net said on September 6, 2007 7:24 AM:

SELECT ‘Index Name’ = ind . name , ‘Statistics Date’ = STATS_DATE ( ind . object_id , ind . index_id

Anonymous comments are disabled

About SQL Master

**__________________________________** SQL Server MVP, Sr. DBA & industry expert. - Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.