Great article! A minor typo (I think): Exercise #1 refers to "Human.Resources.Employee table". I think it should be "HumanResources.Employee table". What do you think?

Also I think the Level 3 link...

Steve Jones - Editor (4/23/2009)

---

I think the answer is correct, but I have added a warning to the explanation so that people that might not read the discussion will see...

Matt Miller (6/16/2008)

---

Having done some amount of testing on this - while this scenario is certainly convenient in some scenarios, it has a tendency to perform on par with CSQ's,...

Check out this link on chargebacks:

http://www.computerworld.com/managementtopics/management/itspending/story/0,10801,99697,00.html

At the moment, I agree with former Ace Hardware Corp. CIO Paul Ingevaldson: "He thinks the best alternative is a system where all the top...

Mick Dugan (2/13/2009)

---

This is pretty neat, but what I've REALLY been looking for for ages is the ability to pass an entire .Net dataset to a proc. Of course,...

Yeah... I'm curious too. Who is it?

Wooh ... this is some article. Great job!

Excellent article! :smooooth:

Very impressive topic and easily readable!

I look forward to your future articles!

Henrik, you type fast.

OzarkMountainMan (12/9/2008)

---

Couldn't you solve the design problem by creating a new table (or series of tables) that contain all of the customer data in them with customer ID's to separate...

I'm practically perfect in every way. :hehe:

I agree. It makes sense to me that Microsoft could profit handsomely by supporting...

I learned about using conventional joins by reading these articles.

Joins Clarified By Sanket Naik http://www.sqlservercentral.com/articles/Miscellaneous/joinsclarified/1333/[/url]

A Refresher on Joins By Jambu Krishnamurthy http://www.sqlservercentral.com/articles/Basic+Querying/2937/[/url]

Hidden RBAR: Triangular Joins By Jeff Moden http://www.sqlservercentral.com/articles/T-SQL/61539/[/url]

I found...

Christopher Stobbs (12/2/2008)

---

Good point Steve, I was asking just yesterday about the left join vs NOT Exists, and well Gail gave me a very good visible answer and well ......

I also enjoyed the article. I like that you include applications and explanations of best some practices, e.g. the discussion on using a SELECT instead of an IF under...