If you ever wondered why a query that looks harmless is performing poorly despite having indexes in place, the answer could non-SARGable queries. First appeared on SQL SERVER – Catching Non-SARGable Queries in Action| SQL Authority with Pinal Dave
