Comments posted to this topic are about the item Find Duplicate Indexes
"Keep Your Stick On the Ice" ..Red Green
Awesome query! Solved my headache today
Ouch! This doesn't take into account the sort order of the keys! It will identify these two indexes as duplicate:
CREATE NONCLUSTERED INDEX [idx01] ON [dbo].
CREATE NONCLUSTERED INDEX [idx02] ON [dbo].
Pretty sure that's not correct.
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.
Viewing 4 posts - 1 through 3 (of 3 total)