I recently switched from postgres to mssql.
I first encountered this issue: Unique index studio
where studio does not generate a nonclustered index for nullable unique columns.
I removed all unique constraints through the designer on such cases. For normal columns, studio will generate an update script to drop the unique index. However, it does not do that for joincolumns.
So I am forced to write my own update scripts
- to add nonclustered indexes
- to remove unique indexes for join columns