• SQLRNNR (12/20/2012)


    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.

    Let us all "Agree" to "Disagree" and come to a point that today's Question has a take-away on Filter Index 😀

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter