» sql improvements (RSS)
Sorry, but there are no more tags available to filter with.
(Reposted from my msmvps.com blog)
SARGable is an adjective in SQL that means that an item can be found using an index (assuming one exists). Understanding SARGability can really impact your ability to have well-performing queries. Incidentally – SARGable is short for Search ARGument Able.
If you have an index on phone numbers using LastName, ...