Stewart "Arturius" Campbell (12/20/2012)
IMHO, I think the correct answer here will be "It depends".It depends on whether filtered indexes are utilised or not, etc.
However, it could be that the PO intended that the use of filtered index(es) is implied (or should be assumed)...
I disagree that "It depends" with this question. It was asked if it was simply possible. No need to consider filtered indexes, you just need to know if there is any possible way to insert multiple nulls into a unique constraint - imho.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events