Hustle and Bustle to Kick off September
September is kicking off with a boom for me. In one week, it seems I will be here, there and...
2011-09-07
821 reads
SQL RNNR
Hustle and Bustle to Kick off September
September is kicking off with a boom for me. In one week, it seems I will be here, there and everywhere. Between SQL, PASS, Family, and User Group –...
2011-09-07
12 reads
S3OLV September 2011
I really meant to get this post out last week. My apologies, but here is the post finally. Along with...
2011-09-06
792 reads
S3OLV September 2011
I really meant to get this post out last week. My apologies, but here is the post finally. Along with the post, I also had meant to get the...
2011-09-06
9 reads
Windows 7
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little...
2011-09-01
600 reads
Windows 7
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little warning and error message to greet me. My activation...
2011-09-01
11 reads
Bitwise and Derived Table revisited
Today I am going to revisit two posts from the past couple of weeks. I want to revisit them just...
2011-08-31
1,812 reads
Bitwise and Derived Table revisited
Today I am going to revisit two posts from the past couple of weeks. I want to revisit them just to make some minor updates and clarifications. This is...
2011-08-31
15 reads
Precision and Scale
As is the case with many of my topics of late, I came across this one by helping somebody else....
2011-08-24
2,990 reads
Precision and Scale
As is the case with many of my topics of late, I came across this one by helping somebody else. In SQL, we should be well aware of Precision...
2011-08-24
22 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