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,715 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
394 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
569 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,313 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,226 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
979 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,471 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,365 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
564 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
607 reads
Blogs
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers