8 September 2012

SQL 2000: Duplicate Index Finder

As I detailed in 2012, 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_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_SQL2000_finddupes – A script that goes through all the tables in a database and looks for duplicates, based on the output of sp_SQL2000_helpindex.

The scripts are current as of 19 June 2020, with no known issues at this time. Keep in mind too that SQL Server 2000 has been out of support for a number of years.

%d bloggers like this: