OK, had to look it up. I didn't know anything about U-SQL. Still don't really.

We are a small shop with half a dozen programmers and as many other IT personnel. We develop software that we only use in house, do not sell. We have...

chrisn-585491 (9/27/2016)

---

I like much of what I see from Microsoft, but most of the issues I have with Redmond, aren't technical issues or a reflection of engineering ability, but management...

Thanks for the script. I'll give it a try.

Thanks for another good article in the series.

Comparing goals of creator to consumer? This makes it sound like the creator creates his own goals. From my experience the creator doesn't set the goal of what he is...

Nice script. I will have a use for this. Thanks.

You're too modest. It's not just for newcomers. Us old folks forget the simple things and can use reminders now and then.

Pictures. I like pictures. If you can draw me a map of the big picture, then break down each section into smaller pictures, that helps me a lot and I...

Good suggestion.

Thanks for the script.

Jeff Moden (9/23/2016)

---

paolo.bert (9/23/2016)

---

For an introduction to the CROSS TAB technique and pre-aggregation and includes performance testing (although a bit dated now), please see the following article.

http://www.sqlservercentral.com/articles/T-SQL/63681/

For an introduction in...

Should be something like "is null" for the compare. Another gotcha would be to do something like CASE X WHEN NULL, which fails.

Didn't know that. Makes sense.

Oh well...