I've read the article on Wikipedia before. I don't think it's entirely accurate. What does the use of a covering index have to do with SARGable?
Anyway, it's a measure of whether or not the query can use an index. Specifically, whether or not predicates in WHERE clauses and JOIN clauses will prevent the use of an index. There are operators that are SARGable and ones that are not. SARGable operations would include =,>,<, BETWEEN, and some LIKE conditions. Non-SARGable operations would include <>,!=,NOT IN, OR, other LIKE conditions.
The use of a function on a column can render the query Non-SARGable as well.
answered Oct 10 '09 at 08:55 AM
Grant Fritchey ♦♦
According to Wikipedia:
answered Oct 09 '09 at 03:51 PM
Ben Adderson ♦♦