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!

4 Comments

  1. Terri Morton Says:

    Excellent! Looking forward to it!

  2. Nathan Mott Says:

    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?

  3. bobu Says:

    Thanks for speaking at philly.net code camp! it was an very informative presentation!

    thanks again!

  4. David L. Penton Says:

    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


Leave a Reply