Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Today @ 3:23 PM
Points: 42,036, Visits: 39,415
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."

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