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!

So I decided to test it. Here are my observations.

First, I updated...