There’s a technique that I’ve been using for some time now, and been looking for going even further back, which has become immediately available to everyone who can see a query plan (version permitting). Some years back (ok, it was 2010), I started to present at conferences about SARGability and residual predicates. I had a […]| LobsterPot Solutions
For those people who seek seeks, here’s a “Pro Tip”. Suppose you have a query that involves a Scan. It can be a Clustered Index Scan or an Index Scan, it really doesn’t matter. If it’s a Table Scan, then you have a Heap in play, and this tip doesn’t apply. I’m looking for the […]| LobsterPot Solutions
Take a look at this query plan. Yes, that arrow indicates a single row. This is an Index Seek, returning a single row. And yet it’s rubbish. That’s right – it’s rubbish! In fact, I had to provide a hint for it to use this index. A table scan would’ve been better, and this is […]| LobsterPot Solutions
Outside of data consulting through @lobsterpot.com.au, I do comedy (sometimes musical!) and I work as Santa. I was rob_farley on Twitter| Bluesky Social
This month I am hosting the invite for T-SQL Tuesday, which is the first ever T-SQL Tuesday and Festive Tech Calendar crossover.| Kevin Chant