Analyzing CXPACKET waits
One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.
This...
2014-04-09 (first published: 2014-04-04)
4,826 reads
Manipulating Dates and Times in T-SQL
In SQL 2008, Microsoft introduced some new date and time data types to augment the options available in prior versions....
2014-04-08 (first published: 2014-04-04)
7,155 reads
The Untold Story of SQLHotties.com
Back when SQLSaturday was in the #20’s or so I bought SQLHotties.com, thinking it would be good for an April...
2014-04-03
571 reads
SQLSaturday Vegas Style
We are mere moments from the inaugural SQL Saturday (announced a few short months ago) event in fabulous Las Vegas, Nevada. Can you feel the excitement building? The SQLSat...
2014-04-03
11 reads
SQLSaturday Vegas Style
We are mere moments from the inaugural SQL Saturday (announced a few short months ago) event in fabulous Las Vegas,...
2014-04-03
795 reads
Database Design Guidelines For Developers
One of the developers that I work with asked me to write a “brief” (really brief) guide on database design....
2014-04-07 (first published: 2014-04-03)
25,873 reads
Presenting Biml and Team-based Development at PASSDC and BSSUG
I’m excited to present two different sessions in April at DC SQL Server User Group and at Baltimore SQL Server User Group. I...
2014-04-03
565 reads
Thanks For Stopping By
Yesterday I passed 300,000 views on the blog. Recently I went over 1,000 comments. My little joke on Tuesday garnered...
2014-04-03
648 reads
I Know I Shouldn't Shrink My Log file, BUT...
As a managed services DBA, I frequently have to clean up after other people's mistakes. (Come to think of it,...
2014-04-03
1,998 reads
PowerShell GUI Tool – Network Ping – Version 2
The first version of the tool was developed by Amandhally and it can be found in the below path. Thanks...
2014-04-02
551 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