Jumping the Gun - 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-10-02
339 reads
A Lost Day - Blog Upgrades
We upgraded our blog server yesterday, making some changes and better integrating the blogs into the site. We now have...
2008-10-02
501 reads
Managing My Todo List
I think everyone struggles with keeping track of things they need to do, and it's all too easy to get...
2008-10-01
483 reads
Reminder - MVP Andy Leonard Midlands PASS!
Speaker: SQL Server MVP Andy Leonard
Midlands PASS Chapter - October 2, 2008 Meeting
The Midlands PASS chapter will hold our normally scheduled...
2008-10-01
928 reads
A Focus on Novice DBAs: My Upcoming PASS Presentations
The PASS Community Summit 2008 is coming up fast (November 18-21, 2008), and if you are attending and you are...
2008-10-01
607 reads
When Will You Begin Implementing SQL Server 2008?
As I have been talking to DBAs around the country, I have noticed a trend that many, if not most,...
2008-10-01
380 reads
Notes from the Sep 24, 2008 Orlando .Net User Group Meeting
I don't seem to find the time often, but recently I was able to fit in another visit to the...
2008-09-30
1,381 reads
Returning Stuff to Amazon
I've used Amazon for years for the sheer convenience, and recently was the first time I ever needed to return...
2008-09-29
1,468 reads
The Relational Manager and Managerial Relations - Why?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-09-29
1,368 reads
Technical Difficulties
Always something going wrong around here with the podcasts. Today I was editing a couple, or attempting to, and couldn't...
2008-09-29
1,446 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