An Experiment with Deadlocks
There seems to be a myth out there that when deadlocks come a-knocking, then just throw this little directive (ROWLOCK) at it and all will be well. This is...
2019-03-25
14 reads
An Experiment with Deadlocks
There seems to be a myth out there that when deadlocks come a-knocking, then just throw this little directive (ROWLOCK) at it and all will be well. This is...
2019-03-25
244 reads
Weekly reading #8
Good day! Good week! Let’s start it with some news form the Data Platform world!
SQL Internals – Physical Table Structure under...
2019-03-25
240 reads
Improving Performance of the Distributed Replay Utility on SQL Server 2012
Setup the DRU What is it? The Distributed Replay Utility (DRU) on SQL Server allows you to capture Profiler trace information on one or more client servers and then...
2019-03-24
216 reads
ASF 020 video invitation
New podcast’s episode is coming (next Friday) and in the meantime, take a look you can watch that episode’s trailer....
2019-03-23
406 reads
2019-03-23
382 reads
Thinking about Setup and Installation
I’m working the first section of a basic administration course, and the first part of this is installing SQL Server...
2019-03-22
486 reads
Toolbox - Exporting SSMS Results to Excel
I was working on another post when I found myself needing to dump out query results to a grid format...
2019-03-22
756 reads
SQL Server Data Pages on Linux
One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system...
2019-03-22
479 reads
Webinar: Change Detection in SQL Server
Change detection is a critical component of any system that moves data from one structure to another. Most data movement mechanisms are designed to move a subset of the...
2019-03-22
17 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