Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with:

Ron Cash

Member since Jun 2, 2011

Recent Blog Comments By Ron Cash

  • SQL Optimization And ON Clause vs WHERE Clause

    Posted on Jul 31, 2013 at 11:12 PM

    Here is Microsofts take on the subject, it depends on the type of join and it is a matter of when the execution engine applies the clauses. Someone said the ON gets applied before the WHERE. The issue is the ON gets applied before the join. For OUTERS this can be an issue. Microsoft says: There ... read more »

  • SQL Optimization And ON Clause vs WHERE Clause

    Posted on Jun 2, 2011 at 3:37 PM

    Did not have time to read all the responses, so not sure if this was added. In SQL Server the query engine always executes where clauses first, so don't think it would make much diff. in an on clause. However, if you use a sub query with a where clause to substiute for the table with the where fil... read more »