thanks... got to learn something new today... wasn't aware of Profile stats

yep.. I also used the execution...

easy one! 🙂

thanks, was about to ask why am i not getting any output... luckily i saw the reply...:-)

Christian Buettner-167247 (4/12/2010)

---

Paul White NZ (4/11/2010)

---

First one to whinge about the explanation being 'incomplete'...

this is strange... i use windows authentication to connect to an sql server instance and it shows NTLM...

thanks , got to know that my authentication works using NTLM and not...

knew it was second option... unfortunately clicked on the first one though 🙁

Thanks for the question, Paul. Luckily, I have set ANSI_NULLS ON on my servers..:-)

good question, thanks 🙂

thanks for the article... it really helped me improving the performance of my query... 🙂

funny article! 🙂

heard it for the first time... was already fooled by Steve's editorial... so was cautious on this question..:-)

lucky to get 7 points.. 😛

i was also fooled... 😀

thanks for the question... this is also a good link to look at...

http://www.kellermansoftware.com/t-ArticleStrongestAlgo.aspx

thanks :-)... its a good interview question.

thanks 🙂

glad to get 2 points... however had to read the msdn to get the correct answer!