Unique key vs. unique index on SQL Server 2008
I have a table called countries and I define the country_name column to be unique by creating a “Index/Key” of type “Unique Key” on SQL Server 2008 R2. But I have the following questions: will creating “Index/Key” of type “Unique Key” automatically create a non-clustered index on this column? if I change the type from … Read more