Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««123

Self Eliminated Parameters Expand / Collapse
Posted Tuesday, October 10, 2006 6:20 AM



Group: General Forum Members
Last Login: Yesterday @ 5:14 PM
Points: 38,949, Visits: 36,036
Maybe that's the difference... I'm running SQL Sever 2000 Enterprise Edition with SP4.  Just kidding... I get the same execution plans on an SP3a box as well.  I don't know what the difference is because I havn't altered Northwind on either of mine either.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Favorite Quotes:
"Has anyone ever told you that a query you have written runs too fast?" - Dwain Camps - 6 Mar 2014

Helpful Links:
How to post code problems
How to post performance problems
Post #314327
Posted Tuesday, October 10, 2006 8:38 AM


Group: General Forum Members
Last Login: Saturday, August 29, 2015 10:16 AM
Points: 114, Visits: 478
That assumes that the Column_Name field doesn't allow null values otherwise, I believe, if the value does happen to be null setting the @Param_Name to null won't "eliminate" it. Null is not equal to Null.
Post #314383
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse