Find Duplicate Indexes

• Jeff W

  SSCertifiable

  Points: 5207

  More actions

  October 7, 2007 at 2:17 pm

  #95405

  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

  More actions

  June 19, 2008 at 9:52 am

  #831210

  Awesome query! Solved my headache today

• ssinger-815504

  Old Hand

  Points: 339

  More actions

  January 8, 2014 at 3:13 pm

  #1678610

  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: 279

  More actions

  July 11, 2017 at 1:56 pm

  #1950430

  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].