Great question. Easy and containing knowledge.

Did not like this part of the explanation -

The current online help page...

rhythmk (5/13/2014)

---

Ola L Martins-329921 (5/12/2014)

---

Only because you find it easy, it doesn't necessarily is for all...

If you find it easy - good for you and keep it to your self....

Thanks for the easy and informative question. The way to chose answers caused me problems but still a good QOTD.

There are very good and useful rules and paradigms for writing excellent and efficient software.

Unfortunately most software is written with using any of them or using them in a counterproductive...

Jeff Moden (5/5/2014)

---

Even though I strongly [font="Arial Black"]disagree [/font]that BIT is an integer datatype simply because it can't be used in certain bits of math, such as a SUM(), I...

TomThomson (5/12/2014)

---

Good straightforward question.

One minor niggle: using datetime instead of datetime2 (0 isn't a valid datetime2 value) and this is said to be in SQL Server 2012. I would hope...

I have read the post so far and like that you understood the spirit of this Monday Morning Question of The Day.

Thank you all of responding and letting me know...

Ola L Martins-329921 (5/12/2014)

---

Only because you find it easy, it doesn't necessarily is for all...

If you find it easy - good for you and keep it to your self. No...

I will email Steve and ask him to correct that.

Thank...

What is Unbelievable is I see someone get this wrong daily. :smooooth:

TomThomson (5/1/2014)

---

PHYData DBA (5/1/2014)

---

TomThomson (5/1/2014)

---

gbritton1 (5/1/2014)

---

Before I answered this question, I read

It reads, in part:

The hash join has two inputs: the build input and probe input. The query optimizer assigns...

TomThomson (5/1/2014)

---

gbritton1 (5/1/2014)

---

Before I answered this question, I read

It reads, in part:

The hash join has two inputs: the build input and probe input. The query optimizer assigns these roles so...

Is this exactly what your textbook says? ...

gbritton1 (5/1/2014)

---

So, we have conflicting opinions! I suspect that the old Technet article is incorrect, or at least no longer correct. It only makes sense that SQL would...

See lots of discussion about why the right answer is...

Here is a reference to the right answer from TechNet BOL.

Looks like this answer to this question has not...