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!
Archive
Archive for February, 2010
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…