The More I Learn
the more I'm sure that I'm getting dumber with SQL Server.
This week I've been working on some QODs based...
2005-08-09
1,365 reads
Blog Posts
Slip Up
I scan about 30 or 40 blogs these days, all from various SQL Server
people around the globe, and enter the...
2005-08-08
1,468 reads
Tech Review
I got asked by someone to technically review their SQL Server 2005
book, so I'm betting that there will be lots...
2005-08-05
1,463 reads
Job Satisfaction
Interesting post by Andy Leonard.
I'll add in my two cents that you should seek happiness and
satisfaction in your job. I...
2005-07-29
1,536 reads
Done and Out
for a week. I'm leaving for vacation and leaving SQLServerCentral.com
in the capable hands of Andy. He'll be sending out some...
2005-07-15
1,418 reads
SQL PASS Chapter in South Carolina
If you are interested in helping to organize or be a part of an
official Professional Association of SQL Server chapter...
2005-07-15
1,420 reads
Memory Leak
A couple of days ago I noticed that the index rebuild for the search
engine was failing at night. In line...
2005-07-14
1,489 reads
Reboot
Apologies, a minor reboot of the db server this morning. Somewhere we're leaking memory, more details later, so I had...
2005-07-14
1,506 reads
RunAs
When I started working at JD Edwards, I was a corporate administrator
on the windows network. Since the DBAs were a...
2005-07-12
1,549 reads
It's always something
As Phill posts in his blog, we've had a couple interesting threads in the forums where the respect and tolerance...
2005-07-11
1,457 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