Browse by Tags

• age

TSQL to get an index age in a database
06 September 07 06:37 AM | SQL Master | 2 Comments   

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’ Read More...

Filed under: sql server, indexes, system, age