title: Get index creation date from SQL server
body: <p>How can I find the create date of an index. I am using <code>SQL2008 R2</code>.
  I checked <code>sys.indexes</code> but it does not have a create date so I joined the query with <code>sys.objects</code>.  The thing is that the object id for an index and the table containing that index is same.</p>
  
  <p>I am using this query...</p>
  
  <pre><code>select i.name, i.object_id, o.create_date, o.object_id, o.name
  from sys.indexes i 
  join sys.objects o on i.object_id=o.object_id 
  where i.name = 'Index_Name'
  </code></pre>
  
  <p>Thanks!</p>