PASS Summit Volunteers Needed
Well, we are coming around into a new year. With this new year there is once again PASS Summit preparations...
2011-02-16
632 reads
How To: Load Dimension Tables with Integration Services - Introduction
When I first started down the business intelligence and data warehousing road, I needed to learn the foundations of dimensional...
2011-02-16
1,357 reads
February 2011 JSSUG Meeting Tomorrow
Tomorrow, I will be presenting at the Jacksonville SQL Server Users Group (JSSUG) meeting. Please join me for my talk...
2011-02-16
436 reads
SQL Rally Performance Tuning SSAS Session
Last week the final sessions for SQL Rally were announced, and I was very excited to find out my Performance Tuning...
2011-02-16
1,240 reads
MagicPASS February 2011 Meeting
If you're in the central Florida area you're invited to the February 2011 meeting of MagicPASS, South Orlando's SQL Server...
2011-02-15
542 reads
Book Review: The Lazy Project Manager
“There is nothing more uncommon than common sense.” Some attribute the axiom to Frank Lloyd Wright but others are adamant that he’s not the origin of it. Whoever said it had...
2011-02-15
17 reads
Book Review: The Lazy Project Manager
“There is nothing more uncommon than common sense.” Some attribute the axiom to Frank Lloyd Wright but others are adamant that...
2011-02-15
838 reads
DWH Workshop material
As announced in my DWH workshop in Munich, you can find here my
whole ETL solution. Thanks for attending my workshop...
2011-02-15
807 reads
More info on nested views causing performance problems
As if I needed any further convincing that nested views were bad....
The other day I had to write a particularly...
2011-02-15
1,197 reads
Are int joins faster than string joins?
This one comes up a lot on the forums, often as advice given…
“You should use integers for the key rather...
2011-02-15
5,544 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