Table Variable Performance “Fixed” in SQL 2019
Reading the new features for SQL 2019 I spotted this:
One of the most popular posts on my blog last year...
2018-10-03 (first published: 2018-09-25)
2,553 reads
Notes from the September 2018 SQLOrlando Meetup
Notes:
30 registered, 11 attended. No weather or traffic issues. Same as the last meeting we did not send a day...
2018-09-25
269 reads
Query Store Best Practice and Configuration
In my previous blog post I have talked about What is the Query Store and How to setup the Query Store. In this blog post today, I will explain...
2018-09-25
77 reads
SOS to ADS
When Microsoft announced SQL Operations Studio last year, I wasn’t thrilled. The move to a VS Code shell was less...
2018-10-05 (first published: 2018-09-24)
2,474 reads
Where to watch Ignite
In case you aren’t familiar with #MSIgnite, it’s a huge event where Microsoft debuts all the new shiny software that...
2018-09-24
270 reads
Prefixated
Are you a prefixer? And by that I mean a developer – or DBA – who uses prefixes on object names? [DISCLAIMER:...
2018-09-24
274 reads
Introducing Azure Data Studio
If you’re watching Microsoft Ignite or tracking the information coming out of it on social media, then you know that...
2018-10-02 (first published: 2018-09-24)
3,575 reads
Azure Cognitive Services – Search APIs
Throughout this week’s Azure Every Day blog posts, I’ll focus on different APIs available with Azure Cognitive Services. With Azure...
2018-09-24
281 reads
Extended Events and Stored Procedure Parameter Values
One complaint I’ve received frequently is that you can’t see stored procedure parameter values in Extended Events. That is patently...
2018-09-24
507 reads
More PowerShell for fun (and profit) – filter files by date
PowerShell provides an easy way to search for and/or delete just the files you want. Let's look at navigating in...
2018-09-24
740 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