I didn't get the idea of this article.

Good to know the mathematical theory to deal with the problem.

But when you don't mention the TSQL function that handles this situation (

@cschnaars, where do I click to LIKE your comment?

One thing that really annoys me in this community is that bunch of smart asses taking every opportunity to criticize...

thx for sharing, Patrick

I always complain how hard it is to find practical uses of the CROSS JOIN and you showed us a nice example.

Steve

I wasn't aware of this kind of problem, but I am surprised to see how frequent...

Men, I didn't know how common those "reprints" were!!

I checked Google and found 3 of my articles shown in some "serious" blogs out there. And 1 one of them...

Well, I can tell you Mauro showed me his article in January/2011 if that helps you find an answer 🙂

BTW,...

rob

relation is a term we generally use in academic environment and I guess this was the word Ed Codd used when he define the basics for relational modeling.

in day-top-day...

SQLkiwi (2/27/2011)

---

Jeff Moden (2/27/2011)

---

Isn't this a bit like the article you wrote on designing databases? While I agree with all the things you've stated, entire books have been written...

James

The SQL statement was supposed to do it from the first to the last join. Actually I understand that's the way things worked out in old RDMBSs.

But SQL SERVER...

Permap

Good catch! I'm correcting it now.

Thx

Sunny

Usually the query optimizer will evaluate the different sequences when defining the execution plan. So, considering standard situations, your query's performance will be same in both cases.

Nils

Thanks for your comments. You know this 2nd article is in my list, hope I have time to work on it soon 🙂

Good catch... I've never thought about it.

Great article. Short and perfectly clear.

Thank you!

David

I understand your opinion, but I do not agree. I think the most difficult thing when talking about performance is exactly...

Victor

I'd like to bring the word "overhead" to the context I used it in my article. I compared a...