• Furthermore, check out Brent Ozar's sp_BlitzIndex (as Jack mentioned) - it does a good job of isolating potential indexes that are not used, and/or ones that are potentially duplicated: http://www.brentozar.com/blitzindex/

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience