SQL Saturday Orlando
Make sure you make it to the next SQL Saturday event that I will be speaking at October 25, 2008...
2008-09-29
1,307 reads
Polos for SQLSaturday
One of things we've tried to do from the beginning is to provide each speaker & volunteer with a good quality...
2008-09-28
1,360 reads
The September Energy Update - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-09-28
1,347 reads
SMO Videos on JumpStartTV.com
Last month I got to head out to Orlando and spend a couple of days with Andy Warren and the...
2008-09-28
1,672 reads
Data Quality, Part 1: The Discovery
I wrote a post a few months back about a healthcare data conversion project that I’ve been working on for...
2008-09-28
1,968 reads
The New Leader - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-09-28
1,439 reads
Sunday Morning
I woke up early, with my schedule a bit messed up from last week and yesterday. I was tempted to...
2008-09-28
1,431 reads
Midlands PASS October Meeting - SQL Server MVP Andy Leonard
Speaker: SQL Server MVP Andy Leonard
Midlands PASS Chapter - October 2, 2008 Meeting
The Midlands PASS chapter will hold our normally scheduled...
2008-09-26
1,800 reads
Should He Stay or Should He Go?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-09-26
1,419 reads
Cheap Vacation/Travel Books
As you've probably noticed via the blog I read a lot; technical, fiction, and non-fiction. Reading can be an expensive...
2008-09-25
1,731 reads
Blogs
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