SQL Swimmer

So, we’ve had this issue lately at work with our TFS build/deploys causing a significant amount of contention and only...

2012-08-16

2,344 reads

Simply NomCom

So there seems to be some confusion as to what the NomCom’s job is. I have to admit I was...

2012-06-18

622 reads

I submitted my application for the NomCom last week and the polls opened up yesterday. I’ve seen an amazing amount...

2012-06-14

629 reads

I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. The internet...

2012-06-06

609 reads

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

“What exactly did it do on my server?” is the first question a DBA...

Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...

Comments posted to this topic are about the item Let's Talk Certifications

Comments posted to this topic are about the item The Hidden Security Risks of...

Comments posted to this topic are about the item 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]
GO

What 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;