PASS SQLRally is Next Week!
It’s hard to believe, but after months of planning and hard work, PASS SQLRally is next week! I admit that,...
2011-05-02
1,051 reads
SQL Azure and the DAC Pac
When last we left our intrepid hero he had successfully deployed to SQL Azure using the Data-Tier Application Package, a...
2011-05-02
1,905 reads
SQL University: Parents Just Don’t Understand
Welcome to the second week of SSIS this semester at SQL University. Today we’re going to talk about the relationship...
2011-05-02
603 reads
Parents Just Don’t Understand
Welcome to the second week of SSIS this semester at SQL University. Today we’re going to talk about the relationship...
2011-05-02
669 reads
SQL Saturday 74 – Jacksonville FL
I made a 700+ mile round trip down to Jacksonville FL where I was fortunate enough to get to speak...
2011-05-02
889 reads
Foreign Keys Help Performance
I have always put FKs into my database for data integrity purposes. I’ve worked on enough applications that didn’t have...
2011-05-02
1,261 reads
2011-05-02
8 reads
2011-05-02
36 reads
Checkpoints and the Lazy writer
Hi,
Both the lazy writer process and a checkpoint both push in-memory pages out to disk, however that’s where the similarity ends.
The reason...
2011-05-02
20,385 reads
A SQL Server Hardware Nugget A Day – Series Recap
Writing a month long series is always a lot more work than you initially expect. You would think that I...
2011-05-01
643 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