If you write code to SQL Server then you might be interested in this: I have written a tSQLt tdd training course which has helped over 500 people learn both tSQLt and how to apply TDD practices to their SQL Server T-SQL development, you can join the course at https://courses.agilesql.club.

Find duplicate indexes in SSDT

Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5…

Duplicate indexes, one of the most pointless things you can do to a table that just adds pure overhead. No one likes them so SQL Developers do your DBA’s a favour and stop them from ever being deployed :)

This new tool for the SSDT Dev Pack adds a menu item (Tools–>SSDT Dev Pack –> Find Duplicate Indexes) what it does is scan all the projects in the solution (it doesn’t follow “this database” references to examine them, maybe a future version) and then print to the output window a list of all the duplicate indexes based on the table, the columns and included columns - I don’t check anything else so you might actually want a duplicate in some circumstances but these should be very few and far between.

If you double click on the index it will take you to the location in the code where it actually is so you can delete it :)

If you have no duplicate indexes then you should see “No Duplicate Indexes Found.”. Check the output window if you can’t see anything.

Anyway, grab the latest version from https://the.agilesql.club/Projects/SSDT-Dev-Pack

Any problems please feel free to contact me and I will help.


Comments:

Anonymous

December 10, 2015 - 13:59

I just want to report that

I just want to report that after clicking on Find Duplicate Indexes nothing is happening -no output is visible.

Ed Elliott

December 10, 2015 - 14:06

Hi,

Hi,

If you open the output pane, do you see anything there at the very least you should see “No Duplicate Indexes Found.” if you have no duplicates.

ed

Darek

December 10, 2015 - 14:08

Sorry, everything is in the

Sorry, everything is in the Output window. It works great.

Ed Elliott

December 10, 2015 - 14:08

great :)

great :)

Subscribe

* indicates required

Please select all the ways you would like to hear from Agile Sql Club:

You can unsubscribe at any time by clicking the link in the footer of our emails. For information about our privacy practices, please visit our website.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp's privacy practices here.