There’s so much more to SARGability than people think, and people can often miss out on significant performance benefits by not appreciating this. 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 which don’t run as well as they should. This is a talk involving lots of demos, showing plenty of queries and execution plans.

MP4 Video Low 60 MB , MP4 Video Med 89 MB , MP4 Video High 186 MB