Reminder: Upcoming SQL Launch Event in Jacksonville, FL on Sep 12, 2008
The Jacksonville SQL Server Users Group (www.jssug.com) is hosting a SQL 2008 launch event on Friday, Sep 12, 2008 in downtown...
2008-08-27
1,373 reads
Comments on a Recent Visit to Boston
Slightly off topic today.
It's fair to say I'm not a great traveler. Waiting for planes, dealing with the hassles of...
2008-08-26
1,538 reads
Tool Review: Quicken
I've used Quicken for a long time now and it's the center of how I manage finances at home. There...
2008-08-25
1,368 reads
Kindle - On Hold
Just as I was debating whether to take advantage of Amazon's $100 savings offer on the Kindle (with a new...
2008-08-25
1,948 reads
Assessing DB Changes
One of the things I teach in our admin course is that it's not enough to just be the gatekeeper/central...
2008-08-24
1,450 reads
Taking Care of Employees - Storms
As I write this a tropical storm is passing over Orlando and has turned out to be milder than expected...
2008-08-21
1,406 reads
Kindle - On the clock
In a week and a half, I start on the first of my four trips this year for work, and...
2008-08-21
1,463 reads
Deleting Duplicates without a unique key
The following was sent to me by my friend and colleague Dave Miller:
Dave's Email:
Wanted to pass along something I hadn't...
2008-08-21
1,638 reads
SQLSaturday #8 in Orlando - Update (Aug 21)
Registration has been open for only a few weeks and we've got 110 registered so far, a nice start! We...
2008-08-20
1,463 reads
Troubleshooting High Connections & What's The Application Name?
I was visiting with a client recently when they asked me to come take a look at an incident in...
2008-08-20
1,372 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