Indexes fill factor impact on the fragmentation
This is a short post that is considering the indexes fill factor impact on the fragmentation. Analysis of indexes is...
2015-04-01
186 reads
Finally, a Universal Data Integration Utility
Earlier today, the fine folks at the F. Oobar Corporation released a revolutionary product: a universal data integration utility. This...
2015-04-01
742 reads
Exploring AlwaysOn Availability Group Template in Azure
This is one of those posts which is due for a long time. I was really excited when Microsoft announced...
2015-04-08 (first published: 2015-04-01)
6,511 reads
2015-03-31
1,523 reads
Microservices and Databases
I ran across a post on microservices recently and was intrigued. I always like the idea of loosely coupled, independent...
2015-03-31
2,791 reads
Apress April Fools 40% Discount Promo & Healthy SQL
April 1, 2015 – I am delighted to take part in the April
Fool’s Promotion by Publisher Apress, who are
featuring some of...
2015-03-31
1,589 reads
Excel Tip #23: Adding a Trendline to Your Chart
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-04-08 (first published: 2015-03-31)
7,886 reads
PASS Board Update: March 2015
Hello all,
It’s been a while since my last update. Sorry. I’ve just been traveling and presenting and working on books...
2015-03-31
1,106 reads
SSRS report footer is NOT lost in Excel
With all the recent changes and updates within the Microsoft PowerBI universe, SSRS core technology gets less and less attention....
2015-04-07 (first published: 2015-03-31)
14,198 reads
Why I Want to Have Coffee With You
Yesterday I read an article entitled “Why I Don’t Want to Have Coffee With You”, in which the author writes...
2015-04-10 (first published: 2015-03-31)
7,897 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