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
55,360 reads
SQL In The Wild
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
392 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
567 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,132 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,221 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
976 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,469 reads
More on the MVP SQL Server book
If you buy from Manning directly today or tomorrow, there’s a 50% discount . Use the code pop0928 at the checkout....
2009-09-29
1,364 reads
MVP book is available for preorder
Last year a large number of MVPs (mostly SQL Server) got together to write a book with all proceeds going...
2009-09-28
563 reads
Why is CheckDB rolling back transactions?
I saw this one on a forum recently and it’s a fun question to look into.
When running CheckDB on an...
2009-09-24
604 reads
Blogs
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Forums
Parameter sniffing issue with different minutes as opposed to using midnight
Hej, I'm not facing this issue but as I was working another parameter sniffing...
Some query values change when query is run but not others. Why?
Hi everyone I have a 1000 line SQL query that is too long to...
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...