Index Creation Date
Often when troubleshooting performance related issues, it is beneficial to know when new indexes were introduced. However currently there is no easy way to keep track of this information or attain this information. That’s why one of my colleagues and a good friend, Mohamed Sharaf (Blog | Twitter), has submitted a request on Microsoft Connect, Expose index creation date in sys.indexes, Link. Please take a few minutes to vote if you agree .
This post is cross posted on my SQLCAN Blog, MSDN Blog, and SQL server Consultation blog.