Beware of Search Argument (SARG) Data Types

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 Don Peterson » Beware of Search Argument (SARG) Data Types

36 posts, Page 4 of 4

«««1 2 3 4

Beware of Search Argument (SARG) Data Types

Rate Topic

Display Mode

Topic Options

Author

Message

Dave F-425609

Posted Friday, July 13, 2007 6:51 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, February 09, 2009 7:44 PM
Points: 282, Visits: 37

Great article. Very informative.

Post #381447

Dave Ott

Posted Friday, July 13, 2007 8:10 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:30 PM
Points: 21, Visits: 344

Great Stuff

Thanks

Post #381485

wwallace-692342

Posted Tuesday, November 30, 2010 7:42 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 30, 2010 7:37 PM
Points: 1, Visits: 4

This was a great article. I was researching why DevExpress XPO was doing this on the back end as well. Keep in mind, this is derived from the system.data.sqlclient class and most of the ORMs inherit that class to build on top for SQL server.

We realized a 8X difference, on average, from changing the datatype. I will say we have high performance SANs and multi-proc servers to handle the storage and CPU load, but this kept me from having to go clustered and deal with updating multiple servers and increased performance like night and day.

This article was a God send. I really appreciate the effort!

Wallew

Post #1028359

Jeff Moden

Posted Saturday, December 04, 2010 9:54 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:01 PM
Points: 33,111, Visits: 27,037

I agree with many of the others. This is a "hidden" performance problem that a lot of people don't even consider because they don't know about things like data-type precedence. It's one of the primary reasons why some folks think Tally Table functions are slow and why some cursors appear to be faster than certain setbased queries.

Very well done, DC... this should be required reading not only for those learning SQL, but for those teaching it, as well.

--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 #1030284

Evil Kraig F

Posted Sunday, December 05, 2010 1:27 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:35 PM
Points: 5,722, Visits: 6,194

I think this is one of those things in the back of my head I always knew, and just never really appreciated just how intrusive the problem could be.

Awesome article, great presentation, and thank you. You may have just fixed something for me on Monday. BigGrin

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1030348

DCPeterson

Posted Sunday, December 05, 2010 12:30 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 8:38 AM
Points: 1,032, Visits: 390

Thanks, and your're welcome. I'm glad to know that the article was useful.

/*****************

If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

*****************/

Post #1030382

« Prev Topic | Next Topic »

36 posts, Page 4 of 4

«««1 2 3 4

Permissions