June S3OLV Update
This is a real quick update. It has been requested that we go ahead and provide LiveMeeting for tonight as...
2011-06-09
498 reads
SQL RNNR
June S3OLV Update
This is a real quick update. It has been requested that we go ahead and provide LiveMeeting for tonight as well. Thus Charley will be presenting in person but...
2011-06-09
6 reads
Meme Monday – Stupid Questions
This month we have an interesting topic for Meme Monday. This is hosted by Thomas LaRock and the topics revolve...
2011-06-06
576 reads
Meme Monday – Stupid Questions
This month we have an interesting topic for Meme Monday. This is hosted by Thomas LaRock and the topics revolve in some way around SQL Server. As Tom brought...
2011-06-06
15 reads
June 2011 S3OLV Meeting
It’s Grillin’ Time
OK, so we won’t be grilling inside the meeting – or even at the meeting. But it sure sounds...
2011-06-06
469 reads
June 2011 S3OLV Meeting
It’s Grillin’ Time OK, so we won’t be grilling inside the meeting – or even at the meeting. But it sure sounds good. There will likely be Pizza and...
2011-06-06
10 reads
MCITP: 2 Down 2 to go
It’s time for the weekly update. Much like last week, we had more issues with taking this exam today. I...
2011-05-26
594 reads
MCITP: 2 Down 2 to go
It’s time for the weekly update. Much like last week, we had more issues with taking this exam today. I scheduled exam 70-433 for first thing in the morning...
2011-05-26
11 reads
CTE, Recursion and Math
Earlier this month we had a TSQL Tuesday on the topic of CTEs. I bailed on my submission because I...
2011-05-23
1,481 reads
CTE, Recursion and Math
Earlier this month we had a TSQL Tuesday on the topic of CTEs. I bailed on my submission because I already posted some CTE examples and was bone dry...
2011-05-23
25 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