Call for Mentors for The Mentoring Experiment
We’re about to start our second experiment over at The Mentoring Experiment and we need mentors. Last time we picked...
2012-05-04 (first published: 2012-04-24)
1,853 reads
Blog Posts
Can You Dig It? – Determining Index Plan Usage
She Can Dig It!
A while back I was asked, if you can use the plan cache to determine which plans...
2012-05-04
1,448 reads
Denali – Day 4: Editions & Licensing
Denali – Day 4: Editions & Licensing
Editions:
Here is a brief edition summary of Editions available for all sql server from 2005 to...
2012-05-04
624 reads
DQS Domain Validation Rules
A compelling feature of the new Data Quality Services in SQL Server 2012 is the ability to apply rules to...
2012-05-04
754 reads
Living a Dream
It was a little over a year ago that I stood on stage at the Rocky Mountain Tech Trifecta and...
2012-05-04
1,218 reads
Slowing Changing Dimension (SCD) demystified – Part 2
In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type...
2012-05-04
771 reads
SQL Saturday Houston Recap
Last month I made the trip with some other Dallas-area speakers down to Houston’s second annual SQL Saturday event. This...
2012-05-04
593 reads
SQLRally at Starbucks Networking Event
Craig Purnell and I are hosting an informal networking event at SQLRally this year on Friday May 11th from 7-8:30...
2012-05-04 (first published: 2012-04-12)
1,738 reads
Changing Priorities
If you’ve been following this blog for a while, you have probably noticed that the content here has been a...
2012-05-03
714 reads
Content is King: Great (paraphrased) advice from TheOatmeal.com
TheOatmeal.com has provided the absolute best counsel regarding creativity vs marketing. The comic I’m talking about is entitled “How to get...
2012-05-03
845 reads
Blogs
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers