Find Duplicate Indexes

  • Jeff W

    SSCertifiable

    Points: 5207

    Comments posted to this topic are about the item Find Duplicate Indexes


    "Keep Your Stick On the Ice" ..Red Green

  • Sergey Kazachenko

    Ten Centuries

    Points: 1051

    Awesome query! Solved my headache today

  • ssinger-815504

    SSC Veteran

    Points: 229

    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.

  • databoffin

    SSC Veteran

    Points: 265

    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