Pages

Saturday, September 21, 2013

SQL SERVER – Difference Between Unique Index vs Unique Constraint | Journey to SQL Authority with Pinal Dave

Unique Index and Unique Constraint are the same. They achieve same goal. SQL Performance is same for both. Add Unique Constraint ALTER TABLE dbo. ADD CONSTRAINT UNIQUE NONCLUSTERED ( ) ON [PRIMARY] Add Unique Index CREATE UNIQUE NONCLUSTERED INDEX ON dbo. ( ) ON [PRIMARY] There is no difference between Unique… Continue Reading...

Source: SQL SERVER – Difference Between Unique Index vs Unique Constraint | Journey to SQL Authority with Pinal Dave