Calendar Tables in T-SQL
In an earlier blog, we covered a type of auxiliary table (the Tally Table) that can provide a lot of...
2014-03-30
32,890 reads
South Alabama Day of .NET Presentations Downloads
I have been running into longtime SQL Saturday friend Ryan Duclos at SQL Saturday events in Baton Rouge and Pensacola...
2014-03-29
1,197 reads
Houston SQL Saturday #308 – Presenting
Saturday May 10th – Houston SQL Saturday #308
I will be presenting at the upcoming SQL Saturday in Houston on May10th. For...
2014-03-29
1,220 reads
T4 Support in SSDT
Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me. On tuesday night,...
2014-03-29
1,162 reads
All in Fun
My first commercial!
Steve on a HorseThis comes from our DBA Team promotion, which is ongoing this year.
Filed under: Blog Tagged:...
2014-03-28
1,442 reads
Reblog: March 21 to March 27
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-03-28
625 reads
SQL Saturday RVA recap
Wow, what a month. On March 22, 2014, the SQL Saturday train came into Richmond VA (RVA). I was one...
2014-03-28
902 reads
Table Space updated again
Today we have another update for an age old script on this site. You can find the last update to the script here. This time we have a bit...
2014-03-28
12 reads
Table Space updated again
Today we have another update for an age old script on this site. You can find the last update to...
2014-03-28
798 reads
SQLServerCentral Editorial: The Perfect Environment
I write editorials once or twice a month for SQLServerCentral and have fallen out of the habit of mentioning them...
2014-03-28
538 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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