Thanks, Paul! You saved me a lot of time by addressing all the points I wanted to address after reading the explanation of this question.

It never ceases to amaze me...

What bothers me (about the documentation referenced, not about this question) is the relative order of ON and JOIN - how can the ON be processed without first bringing in...

I'm sorry to say that this is a very poor article that includes lots of bad advice.

"1. if the query contains 'ORDER BY...' clause, it is necessary to insert 'TOP...

Sadly, I felt I had to report this question and explanation to Steve. The explanation is not the straight copy&paste from another source we had last week, but it is...

Yup. The reference givenn in the answer points to...

L' Eomot Inversé (4/30/2012)

---

Hugo Kornelis (4/30/2012)

---

One of the links you included in your message is this one: https://www.microsoft.com/sqlserver/en/us/sql-2012-editions.aspx.

On that page, just above the heading "SQL Server 2012 Capabilities", is the...

L' Eomot Inversé (4/30/2012)

---

paul.knibbs (4/30/2012)

---

Look again at the page you just linked to--underneath the big headlines saying what the three main editions are you see the following:

* The Web, Developer...

Chris.C-977504 (4/30/2012)

---

With daily deploys and a weekly major release schedule I don't think you can penalize the QA people for the problems - I think you do have to drop...

Some comments on the specific example in the article and on accountability in software development in general.

First: The specific example. I'd say that Facebook is doing it completely wrong. If...

Interesting question, thanks Koen!

I had it wrong because, like Mohammed, I had to google - and I found this reference that appears to contradict the reference Koen used:

In an Integration...

Toreador (4/26/2012)

---

some harsh responses IMHO. Who knows whether the author made use of a bit of code from the internet 7 years ago and forgot the source, or maybe one...

Ouch! That level of simularity is way beyond coinicidence... :angry::crying::sick:

I'll shoot Steve an email now and ask him to deal with...

I love the "don't know" option, and I agree with the poster above that those who rightfully tick that box should get a point. 😉

In T-SQL, recursion is not as...

(edit: hit send too soon)

L' Eomot Inversé (4/25/2012)

---

this is a bit unfortunate. I...

Thanks! Great question.

Unfortunately, I managed to work out the right solution in my head - and then clicked the wrong options. :facepalm: <-- need a smiley for that!