The Danger of Agreements
I'm speaking in context of Getting Things Done, not a legal or contractual agreement. What brought this up is me...
2011-01-24
807 reads
SQL Saturday #70 - Columbia, SC - Call for Speakers
We're gearing up the advertising for SQL Saturday #70 since we're about 8 weeks out. In keeping with that, our...
2011-01-24
2,016 reads
31 Days of SSIS – Generating Row Numbers (23/31)
31 Days of SSIS
It’s Sunday afternoon and a good time to be putting up post twenty-three for the 31 Days...
2011-01-24
2,501 reads
SQL Saturday #45 Report
This past weekend I attended another SQL Saturday. This one was held in Louisville, KY. Malathi Mahadevan and her volunteers...
2011-01-23
1,363 reads
PASSMN January Meeting This Week
Don’t forget – if you are in Minnesota this week the Minnesota SQL Server User Group (PASSMN) will be meeting on...
2011-01-23
529 reads
Internals and Performance class in Dallas
At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...
2011-01-23
4,046 reads
SQLskills Master Immersion Events 2011
Last year, I tried to attend one of Paul Randal’s and Kimberly Tripp’s SQL Immersion Events, but it conflicted with...
2011-01-23
605 reads
2011 Goals
Last year I posted professional goals along with quite a few other bloggers and it helped to keep me somewhat...
2011-01-23
786 reads
2010 Goals Review
So… this is late. And I missed my q3 goals review all together. Oh well, not much I can do...
2011-01-23
749 reads
Tampa IT Camp Saturday
The first annual Tampa IT Camp will be held on Saturday, March 19th 2011.
What’s an IT Camp?
In the...
2011-01-22
580 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