My 20 SQL Commandments for SQL Server, rewritten from an Oracle article: know your data, test with realistic data, write identical statements, and more tips.
SQL SERVER – Primary Key Constraints and Unique Key Constraints
Primary Key and Unique Key both enforce uniqueness, but they differ in the index they create and in NULL handling. Here are the differences and the scripts.