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,080 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,321 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
342 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
605 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,321 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
869 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Buaran Raya Hub.0853•5504•2311
BCA KCP Buaran Raya Hub.0853•5504•2311 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
BCA Finance WTC Mangga Dua Hub.0853•5504•2311
BCA Finance WTC Mangga Dua Hub.0853•5504•2311 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai...
BCA KCP Arundina Cibubur Hub.0853•5504•2311
BCA KCP Arundina Cibubur Hub.0853•5504•2311 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers