title: What makes a SQL statement sargable?
body: <p>By definition (at least from what I've seen) sargable means that a query is capable of having the query engine optimize the execution plan that the query uses.  I've tried looking up the answers, but there doesn't seem to be a lot on the subject matter.  So the question is, what does or doesn't make an SQL query sargable?  Any documentation would be greatly appreciated.</p>
  <p>For reference: <a href="http://en.wikipedia.org/wiki/Sargable" rel="noreferrer">Sargable</a></p>