One NULL in a Unique Key, and None Across a Join
A UNIQUE constraint allows one NULL but rejects a second, and an equi-join drops NULL keys. Filtered indexes and NULL-safe joins.
Technical Articles for the DBA / Developer
A UNIQUE constraint allows one NULL but rejects a second, and an equi-join drops NULL keys. Filtered indexes and NULL-safe joins.