Understanding SARGability (to make your queries run faster)
Rob Farley is doing a live meeting this month on understanding what SARGable means. It is at 1pm BST and so if you are in the UK will be a very useful hour spent.
for more details go to http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=341
The description of the session is
Understanding SARGability (to make your queries run faster)
SARGable means Search ARGument able. It relates to the ability to search through an index for a value, but unfortunately, many database professionals don’t really understand it. This can lead to queries which miss out on the potential to run much quicker. This is a talk involving lots of demos, showing plenty of queries and execution plans. Any time I’m not typing on the screen, I’ll be waving my hands around to explain things, with apologies to those tuned in through Live Meeting.