Create View dbo.MyUniqueColView With SchemaBinding As Select MyColToBeUnique From MyTable Where MyColToBeUnique Is Not Null GO Create Unique Clustered Index IX_MyTable_MyColToBeUnique On MyUniqueColView ( MyColToBeUnique )
