SQL Saturday #71 Wrap-up
It’s over. It’s finally over. This year, unlike previous years, Adam Machanic (blog|twitter) was very good about delegating the work....
2011-04-04
767 reads
Varying Results with Subquery, ORDER BY, MAXDOP
In the speaker rooms of SQL events everywhere, there is wondrous blog material to be had, free for the picking...
2011-04-04
1,189 reads
2011-04-04
624 reads
SQL University–Recommendations for a Clustered Index
Welcome, SQL University Students to another extension class here at Miskatonic University, home to the Fighting Cephalopods (GO PODS!). Never...
2011-04-04
1,236 reads
Find tables which are most commonly used in Stored Procedures
When you start working on a new project, one of the important tasks as a database developer is to get...
2011-04-04
124 reads
The one bright spot in an otherwise bad day.
April 1st is a fun day for almost everyone. Playing tricks or just enjoying the tricks played by others. For...
2011-04-04
1,263 reads
Meme Monday - what the heck? - OK I'll bite!
Thomas "Tommy Boy SQLRockStar" LaRock proposed a Meme Monday and challenged us to write a SQL Server related story in eleven words...
2011-04-04
904 reads
Powershell Day 4
Day 4 Programming in Powershell Part 2 Now we got some basic information about shell programming operators and other stuff....
2011-04-04
452 reads
Isolating SQL Server from other systems
In a recent explanation about the RSA breach, Rick Wanner wrote on the Internet Storm Center (ISC) Diary:
The traditional paradigm...
2011-04-04
2,163 reads
A SQL Story in Eleven Words or Less
Tom LaRock (blog | twitter) proposed a Meme Monday and his first choice of topics was to write a SQL Server...
2011-04-04
703 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