Tom.Thomson (4/7/2010)
Nice clear question, correct answer, nice clear explanation.The success rate is amazing. When I read the question I thought there would be a large majority getting it right - obviously I was wrong about that.
Thank you, Tom.
As far as the prevalence of ANSI_NULLS OFF in the wild...my personal experience is that it is pretty common - but not in well-organized shops with standards 😉
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi