The book SQL Server 2008 Query Performance Tuning Distilled (Page 118) suggests using unique nonclustered index on the primary key.
I have never thought of doing this...
From what I have read this sound a good idea, but the following link says this will effect DAO and ADO.
here is the link:
Does anybody have any comments?