Unique Indexes Are Code; Non-Unique Indexes Are Data

http://ift.tt/1lXtcor

Unique indexes are the database developer's responsibility. Non-unique indexes can be more easily maintained directly on the production database by an automated process.

from SQLServerCentral.com Articles http://ift.tt/Y4GoHZ