Self Eliminated Parameters

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Alex Grinberg » Self Eliminated Parameters

22 posts, Page 3 of 3

«««1 2 3

Self Eliminated Parameters

Rate Topic

Display Mode

Topic Options

Author

Message

Jeff Moden

Posted Tuesday, October 10, 2006 6:20 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112, Visits: 27,038

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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #314327

Dave I

Posted Tuesday, October 10, 2006 8:38 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 28, 2013 3:26 PM
Points: 114, Visits: 477

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 »

22 posts, Page 3 of 3

«««1 2 3

Permissions