More On Alas Snapshot
Hopefully you had a chance to answer the Alas Poor Snapshot, I Knew Him Well question of the day than...
2014-03-21
453 reads
The power of the baseline
There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!
While...
2014-03-21
712 reads
PASS DBA Virtual Chapter Talk
I almost forgot to tell you about the Database Administration Virtual Chapter meeting next week, March 26th, 2014. I’ll be...
2014-03-21
642 reads
Friday Followup For March 21, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-03-21
349 reads
The power of the baseline
There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!
...
2014-03-27 (first published: 2014-03-21)
2,532 reads
Disheartening Apples
Question: How many Oracle DBAs can you fit in Madison Square Garden?
Answer: None, their egos won’t fit through the door.
No,...
2014-03-21
645 reads
Virtual Lab – New Domain User
This is part of my series on building a virtual lab for use with SQL Server and Windows. You can...
2014-03-20
1,084 reads
Error 701 - Insufficient System Memory - Now what?
This story begins, as so many often do, with a few key elements:1) A client who experienced a problem on...
2014-03-26 (first published: 2014-03-20)
9,562 reads
SQL Server 2014 released April 1st!
SQL Server 2014 has been released to manufacturers (RTM) and will be generally available April 1. Here is the official...
2014-03-20
1,129 reads
InfoWorld Review: SQL Server 2014, by Sean McCown
InfoWorld Magazine (http://www.InfoWorld.com) has published a new article by MidnightSQL owner Sean McCown, “Review: SQL Server 2014 pushes the pedal...
2014-03-20
721 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