Toreador (9/30/2014)

---

hjp (9/23/2014)

---

In short: This type of coding ought to be avoided at all cost! - if you assign value to a scalar variable, make sure you have a uniquely...

edwardwill (9/29/2014)

---

Hugo Kornelis (9/26/2014)

---

... my personal coding standard is to always use aliases for all tables in queries that use two or more tables, but use no alias in single-query...

TomThomson (9/26/2014)

---

The mixed mode in the QotD seems odd to me, though: you define the alias s so surely you should use s.ID instead of just ID unqualified just to...

Gary Varga (9/24/2014)

---

This is a great example of a QOTD describing a "gotcha". If anyone knows any others which they discovered or just know about then I, for one, would...

Select code from question

Copy

Paste

Execute

Insert foot into mouth and chew.

Sorry, Carlo, but you are...

What, all those links but none for further reading on CHTM? I am disappointed!

Just kidding, of course.

Thanks for the laugh!

Good question, mediocre explanation.

This has nothinng to do with the ISNULL being executed or not. The correct explanation would be that the SELECT assigns a value once for each row...

Allow me to rephrase that.

Please don't say...

I fail to see the point of this question.

I personally think the maximum nesting depth of 160-odd is completely irrelevant. Rewrite your code, long before you ever hit this.

But if...

That comment was not directed at you or your proposal. 🙂

One more reason...

DrKiller (9/4/2014)

---

I think the explanation need some work.

CTEs doesn't ALWAYS need a semi-colon in front.

This for example works fine:

DECLARE @tmpVariable INT

WITH cte

AS

(

SELECT 1/0 as 'Result'

)

SELECT *

FROM...

Depending on interpretation of the question, there are three or four correct answers, not two. And the explanation of the correct answers is also wrong. Really a missed opportunity,

"#table dose...

I am torn between two opinions on this question.

It is a good question because of the educational value on how the optimizer works and how indexes are (can be) used.

But...

SQLRNNR (8/22/2014)

---

Raghavendra Mudugal (8/21/2014)

---

TomThomson (8/21/2014)

---

It's...

You asked how to achieve the same speed without nolock. That question suggests that if it would not be...