What is SARGability and why does it matter for performance?

SARGability means a query can use indexes efficiently for filtering.

A predicate is SARGable when SQL Server can use an index seek instead of scanning. Non-SARGable expressions like functions on columns (e.g., YEAR(Date)) prevent index usage. Proper query design ensures predicates remain deterministic and index-friendly.