T-SQL Tuesday #54: Interviews!
It’s T-SQL Tuesday again and this month our host is Boris Hristov (b/t). He has asked us to discuss Interviewing....
2014-05-16 (first published: 2014-05-13)
1,624 reads
Debugging a SQL Server query with WinDbg
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-05-13
2,318 reads
T-SQL Tuesday #54 - Interviews and Hiring
This month’s T-SQL Tuesday is hosted by Boris Hristov (blog/@BorisHristov) and his chosen topic is “Interviews and Hiring” – specifically interviewing...
2014-05-16 (first published: 2014-05-13)
2,479 reads
Technical Interviews – How to Thrive
There’s a trick to technical interviews. Every question is looking for integrity first, and intelligence and energy second. This is...
2014-05-23 (first published: 2014-05-13)
2,788 reads
T-SQL Tuesday #54: An Interview Invitation
It’s time for another T-SQL Tuesday! This month’s blog party is hosted by Boris Hristov (blog | twitter) and the subject...
2014-05-13
780 reads
Filetable–Nesting folders and files
In previous posts I showed how to create a folder in a Filetable and also how to the create (and...
2014-05-12
1,095 reads
Writing Another Question of the Day
The most recent one I wrote was a “question from error message” pattern. An experienced DBA should get it easily,...
2014-05-12
363 reads
Last Weeks Top “Reading” Links #83
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-05-12
881 reads
Notes From SQLSaturday #298
The trip didn’t start smoothly for this one. Wed night I was really sick with some kind of stomach flu....
2014-05-12
436 reads
Making a Difference – #SQLFamily
When I started with the SQL Community I was first encourage to start blogging which I started in Sept of...
2014-05-12
1,214 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
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