Select SIFISO Blogs

For a while now, I have ensured that the source code of new projects that I have undertaken (in both...

2015-10-26

246 reads

Execute All Packages Within SSIS Project Catalog

The SSIS Project Deployment Model is great! It really is the best thing since sliced bread! I specifically appreciate the...

2015-07-15 (first published: 2015-07-06)

2,814 reads

When SQL Server Reporting Services (SSRS) successfully renders a given report control (i.e. Table, Matrix, List etc.), the result set can...

2015-06-24 (first published: 2015-06-15)

2,313 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;