T-SQL Tuesday #51: Doubledown disaster
Jason Brimhall is hosting the 51st T-SQL Tuesday this month with “Place your bets!.
It’s always a gamble when buying a...
2014-02-14 (first published: 2014-02-11)
1,583 reads
DELETE operations on tables
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-11
909 reads
[SQL Snacks Video] The What, Why, and How of Instant File Initialization with SQL Server
Instant File Initialization (IFI) is an interesting topic with regards to how SQL Server works with storage. It is an...
2014-02-11
651 reads
Correlation Does Not Imply Causation
One of the biggest mistakes we can make when troubleshooting is to confuse the necessary responsibility of observing activity that...
2014-02-11
1,512 reads
T-SQL Tuesday#51 - Place Your Bets - In-Place Upgrade.
I’m not much of a
betting man, but if I had to bet that I would participate in this month’s T-SQL
Tuesday...
2014-02-11
2,015 reads
Should I learn PowerPivot yet?
Rob’s got a good post called What is Power Pivot’s #1 Competitor? which has some great comments, as well as...
2014-02-11
703 reads
My Experience Aboard SQL Cruise 2014
Where do I begin? First let me say, WOW what an experience!
How it All Began
When I first heard about SQL...
2014-02-11
1,381 reads
T-SQL Tuesday #051: Always Hedge Your Bets
It's time for T-SQL Tuesday again and this month's host is my former co-worker, the @SQLRNNR himself, Jason Brimhall. Jason's...
2014-02-11
726 reads
Office 365 technology – What powers Power BI in Office 365? #0365 #powerbi
Power BI for Office 365 is a new self-service business intelligence (BI) offering enabling businesses to gain insights from their...
2014-02-11
739 reads
SQL Server – Using Tools to Analyze Query Performance
Here is the session I gave for the techies at Microsoft about in-built tools available in SQL Server to analyze...
2014-02-11
968 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