SQL Confessions
I had a brainstorm of an idea for a group of articles on my blog a couple of weeks ago...
2010-12-13
514 reads
SQL RNNR
SQL Confessions
I had a brainstorm of an idea for a group of articles on my blog a couple of weeks ago and am finally getting around to putting it together....
2010-12-13
8 reads
Bundle of Joy
After baking for 9 months, our bouncing baby girl has finally arrived. She arrived Thursday Dec 2, 2010 at 8:28...
2010-12-09
635 reads
Bundle of Joy
After baking for 9 months, our bouncing baby girl has finally arrived. She arrived Thursday Dec 2, 2010 at 8:28 AM (PST). There were no complications and the delivery...
2010-12-09
5 reads
December 2010 SSSOLV Reminder
Here is a quick reminder and a repost of the announcement from last week.
This month we will be broadcasting the...
2010-12-08
852 reads
December 2010 SSSOLV Reminder
Here is a quick reminder and a repost of the announcement from last week. This month we will be broadcasting the meeting once again. This month the technology bug...
2010-12-08
9 reads
December 2010 S3OLV Meeting
It is amazing how the months just seem to fly by these days. I probably say that every month. It...
2010-12-01
551 reads
December 2010 S3OLV Meeting
It is amazing how the months just seem to fly by these days. I probably say that every month. It seems appropriate though. This month we will be broadcasting...
2010-12-01
6 reads
Drumroll Please…
Defensive Db Programming Chapter 10
After dragging this review on for months now, it is finally time to bring this bad...
2010-11-29
1,386 reads
Drumroll Please…
Defensive Db Programming Chapter 10 After dragging this review on for months now, it is finally time to bring this bad boy home and wrap it up. I have...
2010-11-29
13 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
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