Archive

Archive for February, 2010

SQLBits VI

February 17th, 2010 No comments

SQLBits VI comes to London on the 16th April 2010.

The event is being promoted as the best event yet and best of all…it’s free! So register today!

SQLBits

Tags:

SARGable Queries

February 13th, 2010 No comments


You may have seen the term SARGable in blogs or forums and wondered what it means. To start with, SARGable is pseudo-acronym which stands for Search ARGument. A query is considered sargable if the WHERE clause can take advantage of an index to speed up the query. A non-sargable query implies that the WHERE clause (or part of it) cannot use any available indexes which could result in a table or index scan and possibly slow down query performance.
Read more…