Fall Means Election Season
While it’s not officially Fall yet, it is definitely Election Season. Elections for the PASS Board of Directors opens up...
2015-09-25 (first published: 2015-09-11)
866 reads
Extended Events – Event Anatomy
As a follow-up to the introduction to what an Event is, it makes sense to discuss the components of an event. What makes up an event? What is the...
2015-09-11
14 reads
Extended Events – Event Anatomy
So far in these brief discussions about Extended Events, I have covered several core concepts including a basic introduction into...
2015-09-11
619 reads
Work of art – the intra query parallelism deadlock graphs
Look at some of the graphs produced by the intra query parallelism deadlocks, below.
Bart Duncan explains this “phenomenon” (bug, rather)...
2015-09-10
1,378 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...
2015-09-10
41 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...
2015-09-10
10 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...
2015-09-10
376 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...
2015-09-10
702 reads
The #TSQL2sday #70 roundup
Time for the T-SQL Tuesday #70 roundup! I asked people for their best enterprise management strategies, and they responded beautifully....
2015-09-10
766 reads
IT/Dev Connections conference sessions next week
Next week is the wonderful IT/Dev Connections conference in Las Vegas, and I’m proud to announce that I’m presenting two...
2015-09-10
481 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
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