8 September 2012

SQL 2000: Duplicate Index Finder

As I detailed earlier this year, 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 29 September 2017, with no known issues at this time.

%d bloggers like this: