tfifield (12/22/2011)

---

Awesome article, Paul. Very informative. I just might try out the QUERYTRACEON and see...

Happy to have chosen the wrong answer. 🙂

32 seems much more reasonable anyway.

Only a year too late...

http://sqlblog.com/blogs/paul_white/archive/2011/12/23/forcing-a-parallel-query-execution-plan.aspx

Adding in case other Bingooglers find this thread.

insert into #q

select 'ABC' UNION ALL

select 'ABC ...

Very nice work, thank you.

Good to see so many people finding this one easy.

It is 'explained' (perhaps 'documented' would be a...

Are the people who use SAP called saps*?

* A foolish and gullible person

Good question. If you had wanted to be really sneaky...

DECLARE @Example TABLE (col1 VARCHAR(10))

INSERT @Example VALUES ('X'), ('X' + SPACE(1)), ('X' + SPACE(2))

SELECT COUNT_BIG(*) FROM @Example AS e WHERE...

L' Eomot Inversé (12/16/2011)

---

Yes, any unique constraint on that column makes it "work" (including those that allow null); as does any unique constraint on the ID column in the other...

L' Eomot Inversé (12/16/2011)

---

SQL Kiwi (12/13/2011)

---

I suppose we could also wonder about the relevance of the title, whether there is any guarantee the join will produce any rows or not,...

GilaMonster (12/16/2011)

---

Yes, which quite frankly is a problem in and of itself. Great...

Not at all, sadly 🙁

Replying to the wrong post here (I see you worked it...

Clearly I will need to work harder at surprising you in future 🙂

You're...