Brandie Tarvin (7/23/2014)
There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to the natural composite PK has been a useful method of creating a unique (and clusterable) PK.
What do you mean by "adding that [IDENTITY column] to the natural composite PK"? If you have a composite key of (A,B) would you really add an IDENTITY column (idn) and make the clustered primary key (idn,A,B) or (A,B,idn)? That's how I read what you've written but I'm guessing you probably mean something completely different.