Why is my index not being used? Explain sargability.

Answer preview

Sargable (Search ARGument able) means a predicate can be satisfied by an index seek. The rule is simple: the indexed column must appear bare on one side of the operator, compared against a constant or parameter — wrap it in a function or arithmetic and the index is dead.…