Left outer join vs NOT EXISTS
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
2010-03-25
5,209 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
Left outer join vs NOT EXISTS
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
2010-03-23
12,672 reads
The Root of all Evil
Or “Shot gun query tuning”
There have been a fair few forums questions in recent months asking for help in removing...
2010-03-11
441 reads
NOT EXISTS vs NOT IN
Continuing with the mini-series on query operators, I want to have a look at NOT EXISTS and NOT IN.
Just one...
2010-02-18
56,127 reads
Getting here from there
Another month, another blog chain, this time started by Paul Randal. I got tagged by both Grant and Steve, on...
2010-01-21
395 reads
SQL Pass session evaluations
I finally got the last of my PASS Summit session evals and so, like someotherpeople, I thought I’d make them...
2010-01-13
572 reads
IN vs INNER JOIN
Often in forum threads discussing query performance I’ll see people recommending replacing an INNER JOIN with an IN (or recommending...
2010-01-12
21,592 reads
Are trivial plans cached?
It is sometimes said that trivial execution plans are not cached and queries that have such plans are compiled on...
2009-12-08
1,236 reads
The most optimal join type
What’s the best join type for a query? Should we aspire to seeing nested loop joins in all our queries?...
2009-11-24
980 reads
TechEd Online Interview
Back in August at TechEd Africa I did a TechEd Online interview with Frikkie Bosch. Frikkie’s the marketing manager for...
2009-09-30
1,472 reads
Blogs
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Forums
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
What Can AI Really Do?
Comments posted to this topic are about the item What Can AI Really Do?
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers