Review: Tell Me How I’m Doing
I found Tell Me How I’m Doing by Richard L. Williams at the local library. It’s a book about giving...
2014-02-11
611 reads
Who are your victims?
Or….deadlock notifications.
In my previous post I talked about having your own database(s) and what information you could be collecting. One...
2014-02-11
600 reads
HDFS Explorer – Manage HDFS Storage from Windows
f you’re planning to use HDFS Explorer with the Hortonworks Sandbox or Cloudera VM, you’ll need to define your Hadoop...
2014-02-11
1,506 reads
Why is Your SQL Server Slow? Here’s a Hint
I was talking recently with my friends and former colleagues at Idera about the things that slow down SQL Server....
2014-02-11
1,090 reads
T-SQL Tuesday #51 – Place Your Bets
It’s T-SQL Tuesday time again and Jason Brimhall is hosting this month’s event. He used to live in Las Vegas,...
2014-02-11
790 reads
Why I just became a Microsoft Employee
I have been an independent consultant (IC) for quite a while now. In an amazing number of coincidences, or just plain...
2014-02-11
1,510 reads
Impala Performance Update: Now Reaching DBMS-Class Speed #cloudera #bigdata
Since the initial beta release of Cloudera Impala more than one year ago (October 2012), we’ve been committed to regularly...
2014-02-11
496 reads
#TSQL2sDay – Data marts across a shaky WAN link
It sounded good in principle, especially given the requirements and the limitations:
We needed our various sites to be able to...
2014-02-11
710 reads
How Big Data Will Transform Coaching in the NBA #miamiheat #bigdata #nba
There’s a staggering amount of information an NBA coach would have to hold in his head to do his job...
2014-02-13 (first published: 2014-02-11)
1,662 reads
Calculating the length of a hash in SQL Server
Some time ago I added a script component to a few SSIS packages to compare rows with each other using...
2014-02-11
2,605 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