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
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
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
2010-03-23
10,407 reads
Or “Shot gun query tuning”
There have been a fair few forums questions in recent months asking for help in removing...
2010-03-11
427 reads
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
46,318 reads
Another month, another blog chain, this time started by Paul Randal. I got tagged by both Grant and Steve, on...
2010-01-21
388 reads
I finally got the last of my PASS Summit session evals and so, like someotherpeople, I thought I’d make them...
2010-01-13
558 reads
Often in forum threads discussing query performance I’ll see people recommending replacing an INNER JOIN with an IN (or recommending...
2010-01-12
15,132 reads
It is sometimes said that trivial execution plans are not cached and queries that have such plans are compiled on...
2009-12-08
1,166 reads
What’s the best join type for a query? Should we aspire to seeing nested loop joins in all our queries?...
2009-11-24
971 reads
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,461 reads
By SQLBalls
Hello Dear Reader! It's been a while since I had time to sit down...
I was writing some dynamic SQL that generates some SQL statements to load my...
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Hi Team, I have a requirement to track any insert/update/Delete operations happened against Database...
Hi Experts. We recently set up a second location. our software at our first...
I am trying to migrate a DB from an old dying laptop to a...