Business of Software 2008 - Pecha Kucha
I'm starting a series of blog posts from the Business of Software conference
that I attended last week in Boston. If...
2008-09-15
753 reads
Announcing SQLSaturday #10 - Tampa 2009
Pam Shaw & Wes Dumey are leading the charge for the 2nd annual Tampa SQLSaturday on January 24, 2009. They are...
2008-09-14
482 reads
SQL Code Review - Scalar Variables
One very common mistake I see when reviewing code is the case where the select statement is returning multiple rows,...
2008-09-14
539 reads
Business of Software 2008 - YCombinator - Jessica Livingston
I'm starting a series of blog posts from the Business of Software conference
that I attended last week in Boston. If...
2008-09-12
770 reads
Kindle - The Two Week Followup
It's been two weeks since I got the Kindle. Actually it will be two weeks in a few hours. I've...
2008-09-12
988 reads
Vacations Part II
One of the big decisions around vacations is whether it should be a 'do something' vacation or a 'do nothing'...
2008-09-11
1,258 reads
Business of Software 2008 - Dharmesh - On Startups
I'm starting a series of blog posts from the Business of Software conference
that I attended last week in Boston. If...
2008-09-11
800 reads
Chrome
I'm not usually much of a beta software guy, but I saw the new Chrome browser (http://www.google.com/chrome) from Google last...
2008-09-11
772 reads
2008-09-11
427 reads
Blog Review - Yours & Mine
It's pretty common to see a mild plea from blog authors asking for feedback, or ideas about which to write...
2008-09-10
425 reads
Blogs
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