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,766 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
429 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
52,298 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
559 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
18,153 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,191 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
975 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,463 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers