Cleaning up Query Store data after database restore
Query Store is a very powerful tool for performance tuning, if you are not using it already you should!! It...
2018-08-29 (first published: 2018-08-13)
2,093 reads
Measuring Query Execution Time: What Is Most Accurate
Probably the single most important factor when deciding which query to tune, or actively tuning a query, is how you...
2018-08-28 (first published: 2018-08-13)
2,741 reads
Employee Agreements & Contracts: Anti-Patterns (31 minute video)
When you take a new job in software engineering or in IT, within the paperwork there often lurks an employee agreement: a contract between you and your employer. In...
2018-08-13
27 reads
The New SQL Provision Dashboard
As much as I liked the ability to quickly and easily build development and test databases with SQL Provision, I...
2018-08-31 (first published: 2018-08-13)
2,635 reads
Top 5 Reasons You Should Be Excited About Power BI Composite Models
In July there were many exciting new features that were released to Power BI, but perhaps the most eagerly awaited...
2018-08-28 (first published: 2018-08-13)
3,015 reads
Fastest Way to Find Row Count of All Tables From All Databases in SQL Server
There are many times you as DBA or Developer needs to get all row count from all tables or row...
2018-08-13
8,281 reads
Warning: Expect Delays
Imagine you are driving somewhere – to work, to the mall, wherever – and you encounter a massive traffic jam. Wall-to-wall, bumper-to-bumper,...
2018-08-24 (first published: 2018-08-12)
2,035 reads
SQLSaturday Baton Rouge thank yous
Hello everyone who was at #SQLSatBR this year!We had a huge early morning wave of attendees this morning that inundated our sponsors just like a cooling rain inundated us in...
2018-08-12
12 reads
Database Protection in the Cloud Era
The Cloud is a fun and exciting place to be. Exciting as it may be, even in the cloud, protection...
2018-08-10
296 reads
Money Ball: Fantasy Football Kicks Off Tonight - Jeff's Degenerates
You might think that this blog post is out of place here but I'm hoping use some of the data...
2018-08-10
307 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