I have been running the redundant script from this view:
http://www.sqlservercentral.com/scripts/contributions/1252.asp
The results that come up are strange. It seems that some tables generate a redundant index that has three or four letters and then my initials. Example
A_C_B_SJL
A_A_D_SJL
A_L_E_C_SJL
This index is almost identical to the PK in all instances yet I am unable to find any reference to them outside of this view. What is going on?