How to Think Like the SQL Server Engine, Part 4: How SARGability Affects Statistics

If your query’s Search ARGuments don’t let SQL Server effectively use indexes and statistics, your query plan will get ugly in a hurry. Learn why, plus see how implicit conversions and index key order affect your plans.

[@prasantakswain]

Thanks, it is very useful one..

[@prasantakswain]

what is the alternate and efficient way to avoid the functions in where clause ?

[@TheBrentOzar]

Sure, I teach that in my class Mastering Query Tuning.