Mat has been a Dba since 2007 working in the finance and ecommerce industries in South Wales, UK.

Identity Crisis

I’m sure most people have identity values lurking somewhere in their databases. In fact I would guess that most people...

2012-05-02 (first published: 2012-04-25)

2,483 reads

The first blog post….

Daunting! By way of introduction, I’m Mat This blog is mostly for myself, to document what I know and maybe...

2012-04-03

605 reads

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

No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...

A few years ago I took a new job at Microsoft, working as a...

Comments posted to this topic are about the item Let's Talk Certifications, which is...

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;