THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.

SARGable functions in SQL Server

Hi! - Great that you've found this page, but it's no longer here! You can find the content over at: http://blogs.lobsterpot.com.au/2010/01/22/sargable-functions-in-sql-server/

Published Friday, January 22, 2010 3:51 PM by Rob Farley

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Martin Smith said:

It would be cool as well if SQL Server recognized that a column sorted by datetime is also sorted by date and could leverage this in a "GROUP BY CAST(OrderDate AS DATE)" or when merge joining against a table with dates.

The sargability of casting to date should probably not be relied upon though.

It reads a larger range than optimum and also can give much poorer cardinality estimates (More details here http://dba.stackexchange.com/questions/34047/cast-to-date-is-sargable-but-is-it-a-good-idea )

October 13, 2013 8:56 AM
 

Kamran said:

Essential to every SQL user. Thanks.

January 27, 2017 10:47 PM
 

jake said:

http://webhiveteam.com/demo4_chameleon/blogs/2669/40975/10-facts-that-nobody-told-you-ab

https://www.thetorontobeaches.com/socialize/groups/viewgroup/133-real-racing-3-hack-2-0-the-next-step.html

http://greecefriends.de/blog/Chadmanemoj/searching_through_websites_for_the_best_bullet_force_hack-1337237.html

http://www.arthood.com/blogs/4679/50332/the-best-way-of-roblox-hack

http://greenwichparentvoice.com/user-groups/rules-of-survival-hack-cheet-sheet/

http://brooklynne.net/profiles/blogs/10-effective-ways-to-get-more-out-of-rules-of-survival-hack

http://www.facecool.com/profiles/blogs/welcome-to-a-new-look-of-gunship-battle-hack

http://www.trigridonline.com/trigridcollective/pg/blog/read/5504/now-is-the-time-for-you-to-know-the-truth-about-war-robots-hack

http://webhiveteam.com/demo4_chameleon/blogs/2669/41218/real-racing-3-hack-like-a-pro-wi

http://community.smithvillereview.com/blogs/detail/14780/

http://www.gorelations.com/blogs/3725/29102/how-fifa-mobile-hack-can-increase-your-profit

https://www.bloglovin.com/@johnsimmons2/succeed-with-pixel-gun-3d-hack-in-24-hours

https://fortalent.com/blog/view/s/2018-05-17-the-miracle-of-zombie-tsunami-hack/

http://www.cross.tv/blog/85789

http://www.cinenetworld.com/member/blog_post_view.php?postId=44697

https://www.gamerlaunch.com/community/users/blog/5025626/1893853/5-precious-tips-to-help-you-get-better-at-golf-cla/?gid=535

http://www.gayflorida.com/index.php/jomsocial/groups/viewgroup/906-the-advanced-guide-to-fifa-mobile-hack

https://connect.opensuse.org/pg/groups/59935/looking-for-the-excellent-roblox-hack-technique/

http://www.sobgamers.com/gamer/blogs/post/49689

http://simefuneralforum.com/blogs/gaminghacks/2018/05/23/mind-blowing-method-on-zombie-tsunami-hack/

http://www.fbioyf.unr.edu.ar/evirtual/blog/index.php?userid=56423

http://dailygram.com/index.php/blog/468339/the-most-exceptional-8-ball-pool-hack/

http://greenwichparentvoice.com/user-groups/searching-for-the-best-guns-of-boom-hack/

http://www.allpix.net.ee/blogs/post/13851

http://www.cross.tv/blog/106488

http://www.cinenetworld.com/member/blog_post_view.php?postId=44635

http://greenwichparentvoice.com/user-groups/learn-the-truth-about-gunship-battle-hack-in-the-next-60-seconds/

http://www.sobgamers.com/gamer/blogs/post/49653

https://www.pin2ping.com/blogs/722685/42612/which-appnana-hack-works-best

http://simefuneralforum.com/blogs/gaminghacks/2018/05/21/5-explanation-on-why-msp-hack-is-important/

http://www.remittancesgateway.org/groups/20-wonderful-fortnite-hack-number-16-is-absolutely-stunning/

http://community.effinghamherald.net/blogs/detail/40406/

https://notehub.org/soqth

http://cuisinedrop.com/blogs/4222/34388/here-s-what-people-are-saying-ab

http://www.fbioyf.unr.edu.ar/evirtual/blog/index.php?entryid=68040

http://www.charlottestories.com/groups/15-outrageous-ideas-for-your-dream-league-soccer-hack/

http://www.mysittingbourne.co.uk/blogs/post/2419

http://dailygram.com/index.php/blog/468491/master-the-skills-of-gunship-battle-hack-and-be-successful/

https://www.pin2ping.com/blogs/722685/42642/15-things-nobody-told-you-about

http://www.gayflorida.com/index.php/jomsocial/groups/viewgroup/920-here-is-a-method-that-is-helping-subway-surfers-hack

http://www.petsusa.org/events/the-future-of-zombie-tsunami-hack

https://meetmeattheopera.com/groups/avoid-the-top-10-subway-surfers-hack-mistakes/

https://headwayapp.co/61188-none-changelog

http://www.arthood.com/blogs/4679/50066/7-tips-to-avoid-failure-in-mobile-legends-hack

http://community.effinghamherald.net/blogs/detail/40320/

http://coininfifa.mixxt.at/networks/blog/post.chad.simmons:22

http://community.smithvillereview.com/blogs/detail/14849/

https://gamehackss.pressbooks.com/chapter/everything-you-wanted-to-know-about-gunship-battle-hack-and-were-afraid-to-ask/

http://www.cross.tv/blog/106498

http://coininfifa.mixxt.at/networks/blog/post.chad.simmons:10

https://www.pin2ping.com/blogs/722685/42625/searching-for-the-best-guns-of-b

http://whers1959.booklikes.com/post/1667924/think-you-re-an-expert-in-golf-clash-hack-take-this-quiz-now-to-find-out

http://community.effinghamherald.net/blogs/detail/40375/

http://www.fbioyf.unr.edu.ar/evirtual/blog/index.php?entryid=68034

https://www.thetorontobeaches.com/socialize/groups/viewgroup/131-i-will-tell-you-the-truth-about-msp-hack-in-the-next-60-seconds.html

https://peatix.com/group/227993/view

https://www.thetorontobeaches.com/socialize/groups/viewgroup/140-10-facts-everyone-should-know-about-zombie-tsunami-hack.html

http://www.arthood.com/blogs/4679/50385/how-zombie-tsunami-hack-can-ease-your-pain

http://www.charlottestories.com/groups/fast-track-your-boom-beach-hack/

http://dailygram.com/index.php/blog/468632/free-advice-on-real-racing-3-hack/

http://foodtube.net/profiles/blogs/what-makes-boom-beach-hack-that-different

http://groupspaces.com/gaminghacks/pages/the-best-5-examples-of-golf-clash-hack

https://peatix.com/group/325574/view

https://notehub.org/qcpqk

http://androidhacks.gratisblog.biz/2018/05/09/whats-so-trendy-about-boom-beach-hack-that-everyone-went-crazy-over-it/

http://www.gayflorida.com/index.php/jomsocial/groups/viewgroup/905-more-on-dream-league-soccer-hack

https://www.storeboard.com/blogs/gaming/ten-ingenious-ways-you-can-do-with-msp-hack/893146

https://www.gamerlaunch.com/community/users/blog/5025626/1893854/how-to-learn-about-gunship-battle-hack-in-only-10-/?gid=535

https://meetmeattheopera.com/groups/the-latest-trend-in-gunship-battle-hack/

http://greenwichparentvoice.com/user-groups/the-truth-is-you-are-not-the-only-person-concerned-about-msp-hack/

http://www.tibc.tv/jomsocial/31497-chad/groups/viewgroup/1394-the-ultimate-guide-to-boom-beach-hack

http://webhiveteam.com/demo4_chameleon/blogs/2669/41165/how-to-search-for-the-best-guns

http://www.autolife305.com/groups/top-quality-appnana-hack-you-should-have/

http://webhiveteam.com/demo4_chameleon/blogs/2669/41292/seven-quick-tips-for-rules-of-su

https://www.missunitedstatesagriculture.org/groups/what-is-the-perfect-bullet-force-hack-on-the-web/

http://www.sobgamers.com/gamer/blogs/post/50278

http://webhiveteam.com/demo4_chameleon/blogs/2669/40974/seven-ways-to-tell-you-re-suffer

http://www.beanyblogger.com/hackinggames/2018/05/09/12-ways-you-can-get-boom-beach-hack-without-investing-too-much-of-your-time/

https://connect.opensuse.org/pg/groups/59944/you-will-never-thought-that-knowing-fortnite-hack-could-be-so-beneficial/

http://www.cross.tv/blog/106151

http://www.charlottestories.com/groups/10-facts-about-rules-of-survival-hack-that-will-blow-your-mind/

http://www.mypolonia.com/account/submit/add-blog/added_97390/

http://prnp.org/groups/seven-ways-to-tell-youre-suffering-from-an-obession-with-real-racing-3-hack/

http://dailygram.com/index.php/blog/468357/golf-clash-hack-expert-interview/

June 11, 2018 8:05 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

News

News? Haven't you read my blog?

My Company


Can't find something?

Contact Me

IM: rob_farley@hotmail.com
Twitter: @rob_farley
Skype: rob_farley
E: rob_farley@hotmail.com

MVP (SQL Server)




Certifications








Adelaide SQL UG

Privacy Statement