OK -- I sent you a private message in the forum

After reading the article and the docs, I installed MR on one of my test systems. However, the jobs fail! I get tons of errors like this:

42000] (Error...

Solved it!

My Bad. I chose the wrong variable for StdOut in the EP task

One of my favorite uses for APPLY is to make my queries DRY-er by pre-computing subexpressions. e.g.

with data as (select * from (values

(1,2,3),

(4,5,6)

) v(a,b,c)

)

select a, b, f.future, d.diff, p.past

from data

cross...

ScottPletcher (1/26/2015)

---

g.britton (1/26/2015)

---

Jeff Moden (1/24/2015)

---

Simple. Given a single row that contains StartDate and EndDate columns as DATETIME2 columns, write the code...

Jeff Moden (1/24/2015)

---

Simple. Given a single row that contains StartDate and EndDate columns as DATETIME2 columns, write the code to calculate...

BTW you can get the effect this incorrect query seems to imply:

select * from mytable

intersect

select * from mytable

Hugo Kornelis (1/23/2015)

---

In SQL, you need to make a distinction between the definition of...

Hugo Kornelis (1/22/2015)

---

g.britton (1/22/2015)

---

Hugo Kornelis (1/22/2015)

---

The...

Hugo Kornelis (1/22/2015)

---

The shorter explanation is...

you may be right but the effect is exactly same so the fact that behind the scenes the process is different is probably irrelevant

Just though I'd dispel the notion that only count(*) counts nulls:

select count('null') as count_null from (select null n union all select null) countnull

returns:

count_null

2

Manic Star (1/13/2015)

---

Its possible its trying to run the whole kit and caboodle in one transaction. I don't remember 2k5 well enough to know when it commits, or where you...

For the literalist , the missing definition of the variable @output means the code doesn't run at all. But that's jus nit picking

Good article on some of the complexities here:

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