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,292 reads
Blog Posts
Sometimes, you have to fix it yourself
The Problem
SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice...
2010-02-18
2,018 reads
SQLSaturday Acquired by PASS – Reactions
The Announcement
On February 2nd, PASS (@sqlpass), here, and Andy Warren (@sqlandy), here, announced ownership of the SQLSaturday franchise brand was transferred...
2010-02-18
1,238 reads
sys.dm_os_wait_stats
This is a short note explaining he sys.dm_os_wait_stats DMV.
This DMV returns the following columns/values regarding waits encountered by executed...
2010-02-18
1,322 reads
The Adversity Index
Found The Adversity Index while browsing and thought I’d share. It’s interesting to see the economic trends and I’ll let...
2010-02-18
501 reads
?? ??? ?????????? ?????? ?????? ????? ??? ?
????? ???????, ??? ?????? ???? ?????? ??????????? ??????, ????? ??? ???? ???? ?????? ????? ???? ????? ???? ?????? ????? ?????????....
2010-02-17
344 reads
2010 MVP Summit Held This Week
If you can’t tell what is happening in the above photo, you won’t be alone. Today, at the opening keynote...
2010-02-17
606 reads
DBA.Sleep(8hrs)
I have been pondering recently what helps me to sleep at night. Or, conversely, what prevents me from sleeping at...
2010-02-17
1,331 reads
Development Lifecycle Deployment SSAS, SSRS, SSIS
Many companies have a very rigid development lifecycle for all products or solutions they develop. Deploying to each of these...
2010-02-17
3,927 reads
Development Lifecycle Deployment SSAS, SSRS, SSIS
Many companies have a very rigid development lifecycle for all products or solutions they develop.Deploying to each of these environments...
2010-02-17
876 reads
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers