Don’t Be an Arse
In deference to my British employers, I’ll use their word.
It constantly strikes me how rude, stupid, and unfriendly people can...
2014-04-04
986 reads
Great Companies – Spotify
I don’t know anyone at Spotify, nor have I worked there. However when I see descriptions and explanations like this...
2014-04-04
696 reads
Data Collector in SQLServer 2014 – What’s New !
Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting...
2014-04-08 (first published: 2014-04-04)
3,795 reads
Monthly Reflections – March 2014
After a bit of an enforced sabbatical from blogging (short but boring story), I was interested to see how my...
2014-04-04
678 reads
Using BMC Control-M to Automate Tasks
My largest client recently purchased BMC Control-M to use as our enterprise scheduler. Since this product went live in our...
2014-04-14 (first published: 2014-04-04)
4,010 reads
Analyzing CXPACKET waits
One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.
This wait...
2014-04-04
536 reads
Speaker of the Month, April 2014
I’m really enjoying picking a speaker of the month. It forces me to sit through a lot more sessions at...
2014-04-11 (first published: 2014-04-04)
1,206 reads
Follow Up To A Questionable Trigger
This question of the day didn’t turn out well at all – required too big a leap the way it was...
2014-04-04
506 reads
SQLServerCentral Editorial: Team Reputation
Maybe too serious a topic for a Friday, I wrote Team Reputation because I like working for good teams – who...
2014-04-04
607 reads
Friday Followup For April 4, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-04-04
482 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