philly.NET/PSSUG Code Camp - 11 Oct 2008
I'll be speaking at the philly.NET Code Camp on 11 October 2008 on the topic "Increasing Developer Productivity With SQL Server". I've spoke on this topic at the NorthDallas.net user group and the Forth Worth DNUG as well. I've added some material to it since then. I hope to see you there!
2008-09-05 08:53:57
Excellent! Looking forward to it!
2008-10-11 09:53:57
Thank you for speaking at philly.NET Code Camp. It was a great presentation. Will you be providing your code examples on this site?
Also, there was one point that you touched on in your presentation, that I was hoping you could expand upon. When joining two tables on multiple columns (say 3), what is the difference between putting all three comparisons in the JOIN clause as opposed to just joining on one of the columns and putting the other two comparisons in the WHERE clause?
2008-10-13 08:23:21
Thanks for speaking at philly.net code camp! it was an very informative presentation!
thanks again!
2008-10-13 10:15:39
Nathan,
To more effectively define the join itself, it is best to include any of those predicates in the ON clause associated with the join. Since SQL Server 2000 and moreso with 2005 it will optimize the variations of those queries to achieve the same query plan. Of course, for better support/documentation of these queries I'd recommend putting all of those in the ON clause.
As for my presentation and code, I have it linked from here: pentonizer.com/.../philly-net-code
Thanks,
David