I've inherited a project and I'm seeing something pretty interesting that I haven't come across in the past. Looking for guidance.
The Primary Key on a table is a Unique, Non-Clustered Index and there is also a Unique Clustered Index on same column.
Is there any situation where you'd want this, or should I make alterations so that the primary key is a unique, clustered index?
Thanks in advance.