October 7, 2007 at 2:17 pm
Comments posted to this topic are about the item Find Duplicate Indexes
"Keep Your Stick On the Ice" ..Red Green
June 19, 2008 at 9:52 am
Awesome query! Solved my headache today
January 8, 2014 at 3:13 pm
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].
(
[d5comp] ASC,
[d5jbns] ASC
)
CREATE NONCLUSTERED INDEX [idx02] ON [dbo].
(
[d5comp] ASC,
[d5jbns] DESC
)
Pretty sure that's not correct.
July 11, 2017 at 1:56 pm
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy