THE SQL Server Blog Spot on the Web

Welcome to - 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), 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:

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



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 )

October 13, 2013 8:56 AM

Kamran said:

Essential to every SQL user. Thanks.

January 27, 2017 10:47 PM
Anonymous comments are disabled

This Blog



No tags have been created or used yet.


News? Haven't you read my blog?

My Company

Can't find something?

Contact Me

Twitter: @rob_farley
Skype: rob_farley

MVP (SQL Server)


Adelaide SQL UG


Privacy Statement