I have seen that technique of combining unique indexes with filtered indexes before and it's really great to be able to do that. Thanks for bringing it up.

I really like how you explain many questions at once in your article. That unique constraint VS unique indexes part was one of them.

Best regards,