Koen Verbeeck (7/30/2013)
You can also create multiple unique indexes on the same table, but you can have only one primary key.A unique index can also be filtered, while a PK cannot.
I am not clear with this statement_
A unique index can also be filtered, while a PK cannot
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/