Richard Wilkins

Recent Blog Comments By Richard Wilkins

• SQL Optimization And ON Clause vs WHERE Clause

  Posted on Jul 3, 2011 at 10:57 AM

  The above query is in MS SQL 2005. I forgot to add that. Thanks for your help. Sorry for the typeo above.... read more »

• SQL Optimization And ON Clause vs WHERE Clause

  Posted on Jul 3, 2011 at 10:56 AM

  Type above query is in MS SQL 2005. I forgot to add that. Thanks for your help.... read more »

• SQL Optimization And ON Clause vs WHERE Clause

  Posted on Jul 3, 2011 at 10:54 AM

  What would you suggest to speed up this query? I plan to put the optimized version in a stored procedure. What can I do to the query below to optimize it so that I don't get query timeout errors over our network? Thanks for your help. select count(*) As SCount from SM_Sales_Master where (SM_Sales_D... read more »