Grant Fritchey (7/30/2013)
A pretty common use of unique keys is when you have an artificial primary key for a table, the single most common example is the identity field, but you still need to define the logical key (and any other alternate keys) in order to prevent duplicate storage within the table.
True dat. A common scenario is in data warehousing, where you have a clustered index on the surrogate key of a dimension, and a unique index on the business key of the dimension.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP