TheSQLGuru (5/27/2009)

---

Topical and timely words to the wise from Bart Duncan (someone who REALLY knows what is going on with SQL Server) and isn't just a pretender like myself! ...

Max (5/27/2009)

---

Sometimes it is the job of the dba to make sure that production servers run smoothly and that code being introduced to prod doesn't adversely effect the server or...

Max (5/27/2009)

---

There's shouldn't be any need to validate the second part of the OR clause when the first condition has been met. I would be perplexed if this was the...

No problem. I have to thank you indeed, because you gave me the opportunity to raise one of the most challenging aspects of working as a...

I'm sorry I posted here...

I have to correct myself, I found my old account and it's dated 2004.

I'm sorry, I don't know English well enough to understand if you are referring to...

Hi everybody! I see that "The Thread" is now focusing on bad replies, so please let me know: was this http://www.sqlservercentral.com/Forums/FindPost721477.aspx really a bad reply? Did I deserve the...

I spent the last 10 minutes reading over and over my post, and I can't find the offending sentence that set you up that bad. Please note that English is...

Thinking on the performance side, I can only agree with you, but you can't forget that performance is just one of the qualitites of a good software: what about maintainability?...

Thanks everybody, I think everything is clearer now.

Short circuiting is a topic I've always found interesting, but neved had the time (or skills) to investigate deeply.

I think I can...

She didn't actually find us, but she was linked here from this http://www.sqlservercentral.com/Forums/FindPost720460.aspx thread, that apparently has become a sort of "bulletin board" because all major experts are participating...

Hope you...

I tried the same test code on a SQLServer 2000 box and I get the same results (original tests had been made on a 2005 x64 box).

No news, just a...

Thanks for your opinion, Gail: I longly wished you came across this thread to shed some light.

Can you help us with some ideas on the short circuit side?

Thanks

Gianluca

This is because you're working with constant values: 1/0 is evaluated before the query is executed, I think during the execution plan elaboration.

In my test code this works:

DECLARE @id int

SELECT...