Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email Thank you for your patience.

Thank you to our sponsors:


Understanding SARGability to Make Your Queries Run Faster


Presenter: Rob Farley, LobsterPot Solutions


Session 24: September 16 at 23:00 GMT


Session Details

There’s so much more to SARGability than people think, and you can miss out on some significant performance benefits by not fully appreciating it. SARGable means Search-ARGument-able and relates to the ability to search through an index for a value. Unfortunately, many database professionals don’t really understand it—especially in regard to joins—leading to queries that don’t run as well as they should. This session involves lots of demos, showing plenty of queries and execution plans.


About the Speaker



Rob Farley runs LobsterPot Solutions, a Gold Partner SQL Server & BI consultancy in Adelaide, Australia. He presents regularly at PASS chapters and conferences such as TechEd Australia and SQLBits (UK), heads up the Adelaide SQL Server User Group, sits on the South Australian committee of the Australian Computer Society, and has held Microsoft certifications since 1998 (including MCDBA, MCSD, MCPD, and MCITP). Rob is an MCT and has been a SQL Server MVP since 2006. He has helped create several of the MCP exams, wrote two chapters for SQL Server MVP Deep Dives, and created the PASS chapter map that can be found on the PASS website.


Register now for 24 Hours of PASS!

Copyright 2013 by PASS | Terms of Use | Privacy | Login