THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » DDL triggers » default trace   (RSS)
  • Capturing index operations using a DDL trigger

    Today on twitter the following question came up on the #sqlhelp hash tag, from DaveH0ward: Is there a DMV that can tell me the last time an index was rebuilt? SQL 2008 My initial response: I don't believe so, you'd have to be monitoring for that ... perhaps a DDL trigger capturing ALTER_INDEX? Then I ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 31, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement