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,871 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
446 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,416 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
398 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
575 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,664 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,241 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
983 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,473 reads
Blogs
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Forums
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Alamat Kontak Bank BCA KCU RUNGKUT Telp:08218154392
WA CS (08218154392) Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa...
Alamat BCA KCU Singkawang Telp:08218200233
Hub Via Wa:628218200233 Alamat: Jl. GM Situt No.12 B, Pasiran, Kec. Singkawang Bar., Kota...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers