On the exorcism of Ghost Records
There was a question earlier on one of the SQL forums as to whether or not Ghost Cleanup overwrote the...
2011-06-07
1,893 reads
SQL In The Wild
PASS Summit Session Votes
I blogged a week ago about the sessions that I submitted for the PASS Summit this year. At the point...
2011-05-18
1,082 reads
On Transactions, errors and rollbacks
Do errors encountered within a transaction result in a rollback?
It seems, at first, to be a simple question with an...
2011-05-17
13,293 reads
Pass summit abstracts
I missed the Pass summit last November for a number of reasons, but I’m hoping I can attend this year....
2011-05-10
963 reads
Sql Saturday #83
Frikkie Bosch opened the day with a short keynote giving an overview of Denali, talking mostly from a marketing point...
2011-05-09
807 reads
Indexing for ORs
All of the indexing strategy posts I’ve written in the past have been concerned with predicates combined with ANDs. That’s...
2011-05-03
1,027 reads
Meme Monday: I Got 99 SQL Problems And the Disk Ain’t One
From Tom LaRock’s latest idea…
For a change I’m not going to mention performance (well, not more than once anyway)...
2011-05-02
1,324 reads
To TOP or not to TOP an EXISTS
Earlier this year I had a look at a query pattern that I often see on forums and in production...
2011-04-05
5,900 reads
Statistics, row estimations and the ascending date column
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
2011-03-22
2,082 reads
Q & A from 24 Hours of PASS session
Earlier this week I took part in the 24 Hours of PASS live webcast event. There were far more questions...
2011-03-18
712 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