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