title: How do I find a disabled index on SQL server 2008
body: <p>A while back when I was performing some bulk inserts of data into my SQL Server database, I disabled a number of indexes to improve the insert performance.  I now need to go back and rebuild/re-enable them.</p>
  
  <p>Unfortunately, I'm not sure exactly which indexes I disabled.</p>
  
  <p>Is there a way I can query to identify which indexes are disabled and should be re-enabled?</p>