Help on SQL Server

Index Utilization Report

One day my manager came and told me that he need Index Utilization Report.
He felt that during...

2016-08-29

576 reads

Most common interview questions

1. Tell me about yourself.

Answer - Give summary of your past education and work, skills, and achievements and include your strong...

2016-03-27

168 reads

Interview is a three stage process. Before => Interview => After

A. Before Interview -

1. Most important, ready your Resume/CV. Be confident about...

2016-03-26

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