THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.

24 Hours of PASS – sargability resources

I just did a talk for 24 Hours of PASS on Sargability. I’ve done this talk before (about five months ago at the user group I run and at the PASS AppDev Virtual Chapter).

There are a number of useful resources out there about sargability. I’ve blogged about it before, Brent Ozar has blogged about it, and so on. One thing that I don’t believe has been mentioned much is the use of inverse predicates in a view to hope that one of the sides is treated as a Seek. You can see that being handled in my script, and I’ll try to write a blog post about it some time during October.

I’m also giving this talk on Friday Oct 1 at SQLBits in York, UK. I hope you can come to this – the line-up of speakers is just amazing this time.

Anyway, the script I used is now in a SkyDrive folder at

And some other useful links that I showed during my talk are listed below

Aaron's blog post with the great picture:

Erin's blog post about SQL not being able to add indexes on expressions:

Connect items of interest:

Thanks. Let me be the first to wish you a Happy Christmas and a Sargable New Year. See you at the PASS Summit in November I hope!

Published Friday, September 17, 2010 12:33 PM by Rob Farley
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


This Blog



News? Haven't you read my blog?

My Company

Can't find something?

Contact Me

Twitter: @rob_farley
Skype: rob_farley

MVP (SQL Server)


Adelaide SQL UG

Privacy Statement