MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Sign in
|
Help
Home
Blogs
Media
Groups
All Tags
»
SQL Server
»
indexes
»
age
(
RSS
)
Browse Site by Tags
Showing related tags and posts accross the entire site.
system
TSQL to get an index age in a database
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 )
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on 09-06-2007
Filed under: sql server, indexes, system, age
Page 1 of 1 (1 items)
Copyright © is the original authors. Blog site is an independent site not sponsored by Microsoft. The Yoda blog server and the Brianna SQL server would like to thank www.ownwebnow.com and www.exchangedefender.com. They wouldn't be here and broadcasting without the generosity of Vlad Mazek and his companies.