May 4, 2012 at 12:21 pm
My co DBA has done Index Rebuild Yesterday on a Datbase.
He is out today
Is there any way I can find which tables or indexes got rebuild yesterday
Thanking You
May 4, 2012 at 12:29 pm
its not 100 percent but when an index is rebuilt the statistics get updated. you can use the following to kinda see when the last time it was rebuilt. since it was yesterday should be kinda accurate
SELECT t.name AS Table_Name, i.name AS Index_Name, i.type_desc AS Index_Type, STATS_DATE(i.object_id,i.index_id) AS Date_Updated
FROM sys.indexes i
INNER JOIN sys.tables t
ON t.object_id = i.object_id
WHERE i.type > 0
ORDER BY t.name ASC, i.type_desc ASC, i.name ASC
EDIT: did i use enough kinda's??
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
May 4, 2012 at 1:09 pm
Thank You.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply