SQL Server Performance

TSQL to get an index age in a database

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Sep 6, 2007.

  1. Anonymous New Member

    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’...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2007/09/06/1920.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1920" width="1" height="1">

Share This Page