WolfgangE (9/3/2013)
I thought about making the PK on the identity column, clustered, and add an additional unique nonclustered index on the rest of the columns.
In this case There is no use to make PK clustred index as you are not goung to use it for Query performance better. Keep the clusterd in index on your searchable column (as mentioend in your index ) and make the PK (int) non clustered index. because in any case your query will get benefit if clustered index is on searchable columns .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)