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 » indexing   (RSS)
Showing page 2 of 3 (27 total posts)
  • Function Invertability for SARGability

    My good friend Simon Sabin used the term ‘invertability’ on a Connect item he logged today. Essentially, Simon’s noticed that there are lots of people that use year(someDate), but that the system doesn’t understand that this function doesn’t affect the order of the items in the index. month(someDate) does, but if you’re already using ...
    Posted to Rob Farley (Weblog) by rob_farley on March 23, 2011
  • Probe Residual when you have a Hash Match – a hidden cost in execution plans

    No, this post has nothing to do with airport security, and nothing to do with marijuana. Being honest, this post is only half about Hash Matches and Probe Residuals. It’s more about the types of predicates you can see mentioned in a SQL Server Execution Plan (or Query Plan, but I prefer to call them Execution Plans) – but you may well see some ...
    Posted to Rob Farley (Weblog) by rob_farley on March 21, 2011
  • The SSIS tuning tip that everyone misses

    I know that everyone misses this, because I’m yet to find someone who doesn’t have a bit of an epiphany when I describe this. When tuning Data Flows in SQL Server Integration Services, people see the Data Flow as moving from the Source to the Destination, passing through a number of transformations. What people don’t consider is the Source, ...
    Posted to Rob Farley (Weblog) by rob_farley on February 17, 2011
  • 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 is the ability to seek for items in an index according to a particular set of criteria. If you ...
    Posted to Rob Farley (Weblog) by rob_farley on January 3, 2011
  • 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
  • World Class Training For Them, an Amazon Gift Certificate For You

    We have just two weeks to go before Paul Randal and Kimberly Tripp touch down in the Boston area to deliver their famous SQL Server Immersions course. This is going to be a truly fantastic SQL Server learning experience and we're hoping a few more people will join in the fun. This is where you come in: we have a few vacant seats remaining and we ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 15, 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
  • Paul Randal and Kimberly Tripp - Boston Area - March 29-April 2

    If you've been looking for advanced training in the northeast, your wait is over. Paul and Kimberly will be gracing us with one of their famous ''SQL Server Immersion'' events the week of March 29. This course will cover storage engine internals, indexing and performance strategies, and of course in-depth sections on database maintenance from the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on January 26, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement