SQL 2000: Duplicate Index Finder

As detailed on my personal blog, I ported Kimberly Tripp’s duplicate index finder to Microsoft SQL Server 2000.

You will need to install two scripts into your SQL Server 2000 master database:

  • sp_SQLskills_SQL2000_helpindex – A modification of the built-in sp_helpindex, based on Kimberly’s script, to output the index information for a particular table.
  • sp_SQLskills_SQL2000_finddupes – A script that goes through all the tables in a database and looks for duplicates, based on the output of sp_SQLskills_SQL2000_helpindex.

The scripts are current as of 23 May 2013.

EDIT 2013-05-23: There are no known issues at this time.