Rob Farley

THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |

Home

Blogs

Downloads

Opml

Rob Farley

Rob Farley - Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft MVP (SQL Server) and leader of the SQL User Group in Adelaide, Australia. Rob is also a Director of PASS, and runs training courses around the world in SQL Server and BI topics.

Browse by Tags

All Tags » sqlbits » indexing (RSS)

Using SQL Execution Plans to discover the Swedish alphabet

SQL Server is quite remarkable in a bunch of ways. In this post, I’m using the way that the Query Optimizer handles LIKE to keep it SARGable, the Execution Plans that result, Collations, and PowerShell to come up with the Swedish alphabet. SARGability Read More...

Posted Monday, January 03, 2011 4:54 PM by Rob Farley | 5 Comments

Filed under: sql, indexing, powershell, sqlbits, sqlpass, collation

SARGability isn’t about the left-hand side

This month’s T-SQL Tuesday has me caught slightly unawares. I’m in the UK, having come over for SQLBits , and I’m left writing this with only a few hours to go. The theme this time is on misconceptions in SQL, and this fits nicely with SARGability – one Read More...

Posted Wednesday, October 13, 2010 10:10 AM by Rob Farley | 0 Comments

Filed under: sql, t-sql tuesday, indexing, sqlbits