Conor vs. Non-ANSI NULLs, part 1

I was thinking about indexed views.  Well, more specifically, I was thinking about why indexed views are hard to use.  One of the reasons that they are hard is that there are just so many restrictions.  Anyways, one of the things I’d like to better understand is how many customers actually use ANSI NULLs OFF and specifically _why_ do you use it?  The typical reason we would expect is legacy applications (and that’s a fine reason), but I am curious if there is more to it than just this.

So, you know the email address – conorc (at) microsoft . com – feel free to email me.  I’ll anonymously summarize what I learn, but I’d like to get a feel for how customers approach this little flag.  Are you planning to get rid of you use of this?  Do you plan to keep using it forever?  Does the packaged sql app that you bought still use this?  which one? 

It is in the deprecation path ( So it will eventually go away, but that doesn’t mean that we have nothing to learn from it :).

Happy Querying!

Conor Cunningham


Skip to main content