Unique Index archives - SQL Server with Mr. Denny

SQL Server with Mr. Denny:

Unique Index

Oct 15 2009   11:00AM GMT

SQL Server gets an ANSI compliant unique index … sort of



Posted by: mrdenny
T/SQL, SQL, Index, Unique Index

If you work with any of the other big database platforms you’ve probably noticed that SQL Server’s implementation of a unique index is “different” than the others.  Until now there hasn’t been a way to fix that without using a trigger.  Until now… Continued »