Attend the European PASS Conference 2009 in Neuss Germany
The European PASS Conference will be held in Neuss Germany (near Düsseldorf) from April 22-24, 2009. It will include 36...
2009-01-29
1,575 reads
New Business Cards
I ordered new business cards recently after I gave one to someone that needed to send me something and realized...
2009-01-29
1,586 reads
Ruthless Focus - An Addendum
Forgot I had this, a friend had sent it to a while back as something I might blog about. Mike...
2009-01-28
1,369 reads
PASS Update #3
It's been busy since my last update, lots of stuff to work on! I probably won't get it all in...
2009-01-28
1,447 reads
All the Aggregate Data you Crave with Grouping Sets in SQL Server 2008
As reporting requirements increase, it seems that aggregate functions have thankfully risen to the occasion concurrently. To maintain its competitive edge...
2009-01-28
2,699 reads
Do You Want to Help Provide Feedback on a New Book I Am Writing?
Normally when I write a book, I create a book outline, give it to my editor for feedback, make some...
2009-01-28
4,087 reads
Who Do We Choose to Follow?
Think about your career and the managers, and potentially leaders, that you’ve had in your life. Think about life in...
2009-01-28
2,037 reads
Ruthless Focus - A Different Type of Time Management Philosophy
If you could list all the reasons I work, the number one reason would be to support my family. My...
2009-01-27
1,606 reads
DBA Education
I always consider taking seminars and technical conferences as a key component in my DBA education framework
Last week (Jan 21...
2009-01-27
1,747 reads
It's Your Ship
I saw this book (It's Your Ship) in a Barnes and Noble and the title and cover attracted me. So...
2009-01-27
1,786 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