If people are looking for a GUI for this. Aireforge Studio will check for duplicate, overlapping, missing and redundant indexes from the Advise module. You can download the free trial from http://www.aireforge.com.
Solving data & infrastructure issues via xTEN[/url] and our application, Aireforge[/url].