THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SQL » indexing   (RSS)
Showing page 2 of 2 (15 total posts)
  • Inverse Predicates - look both ways before you cross

    When I’m at the PASS Summit in Seattle this week, I will need to remember that I can’t just step onto the road if I’m walking along the footpath on the right-hand side. In the UK and Australia, where we drive the correct side, it’s fine (just don’t tell my kids), because the cars that are nearest me are coming towards me – except of course, the ...
    Posted to Rob Farley (Weblog) by rob_farley on November 8, 2010
  • 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 of the topics that I presented on at SQLBits a week and a half ago. I often see people refer ...
    Posted to Rob Farley (Weblog) by rob_farley on October 12, 2010
  • Table? No such thing…

    No really – hear me out. Of course you create tables, and you query tables, and we say that data is stored in tables. The table is (rightly) a fundamental part of relational theory. But I find that when I think about queries and how they run, I need to approach the system thinking about the indexes that I’m querying, not the tables. When you ...
    Posted to Rob Farley (Weblog) by rob_farley on September 13, 2010
  • A CASE study in SARGability

    (Reposted from my msmvps.com blog) A recent discussion on Twitter about a query that Denny Cherry was looking at led to this post by Josef Richberg: http://josef-richberg.squarespace.com/journal/2010/1/28/is-a-case-statement-considered-sargable.html, and I thought it might be worth going through a few points on the topic of SARGability. ...
    Posted to Rob Farley (Weblog) by rob_farley on February 1, 2010
  • SARGable functions in SQL Server

    (Reposted from my msmvps.com blog) SARGable is an adjective in SQL that means that an item can be found using an index (assuming one exists). Understanding SARGability can really impact your ability to have well-performing queries. Incidentally – SARGable is short for Search ARGument Able. If you have an index on phone numbers using LastName, ...
    Posted to Rob Farley (Weblog) by rob_farley on January 21, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement