As all DBAs should know, a unique identifier as a clustered index is not an index you wish to have in your database. This script detects such index. It is a good start to investigate your database design.
Copy paste T-SQL code and run it in your favorite database.
The subquery (with alias B) selects the indexes with only one column