Community Member Profile

Ron Cash
Member since Jun 2, 2011

Recent Blog Comments By Ron Cash

  • 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... read more »

Member Account Kinky Solutions Shop
  • Help Wanted - Find Your Next ColdFusion Job
InVision App - Prototyping Made Beautiful With Prototyping Tools