THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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 runs 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 http://cid-32a3bd12bf98b682.office.live.com/browse.aspx/24HOP%20-%20Sargability

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

Aaron's blog post with the great picture:
http://sqlvariant.com/wordpress/index.php/2010/09/1433/

Erin's blog post about SQL not being able to add indexes on expressions:
http://erinstellato.com/index.php/component/content/article/1-latest-news/99-desperately-seeking-seeks

Connect items of interest:
https://connect.microsoft.com/SQLServer/feedback/details/566418/indexes-on-expressions
https://connect.microsoft.com/SQLServer/feedback/details/526431/make-more-functions-sargable

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

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement