Tools › SARGable rewrite

SARGable query audit for SQL Server

If you wrap the column in a function, SQL Server often cannot use the index. Compare the column to a range instead.

Related: datetime to date.

Learn it on a real ticket

Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.

Clock in free