The Log Chain
I ran across a question recently from someone that received a similar message to the one showed in this image:
In...
2015-08-25
1,281 reads
Exploring the Microsoft Azure HDInsight Query Console (No Scripting Required)
As I noted in my previous post, I am not a fan of scripting. In that post we set up...
2015-09-04 (first published: 2015-08-25)
1,313 reads
SQLSaturday & The Speaker Wait List
When a new SQLSaturday event is launched an email is sent to all the speakers who have opted in to...
2015-08-25
640 reads
Assigned reading: FREEPROCCACHE
I don’t often find myself blogging for the sole purpose of showing you someone else’s blog, but today is one...
2015-08-25
658 reads
Automatic Roll Forward Transaction Log Backups
Performing a transaction log backup every 15 minutes has its advantages. But it also has disadvantages. Ever tried to restore...
2015-09-03 (first published: 2015-08-25)
2,576 reads
Query cost and Query Execution time - Difference
This post is my 100th post 🙂 Was inactive in blogging for few years in between. Now back in full flow....
2015-08-25
1,491 reads
Outlier Detection with SQL Server, part 7: Cook’s Distance
By Steve Bolton[
…………I originally intended to save Cook’s and Mahalanobis Distances to close out this series not only because the...
2015-09-03 (first published: 2015-08-24)
2,079 reads
Compressing Outcomes
Find yourself struggling to determine the outcome of attempted compression settings in your database? This should help!
Related Posts:
Failed to Create the Audit File December 31, 2017
Disk Space and...
2015-08-24
9 reads
Compressing Outcomes
You find yourself cruising along, just doing your thing as a database administrator. Then the CIO plops down into a...
2015-08-24
720 reads
WWH of SSIS Zero to Hero in SSIS series (How to Use SSIS ?) TIP #112
Hello Friends,
Welcome, back to Zero to Hero in SSIS series(Post #110). In last post #111 ,We gone through the WW...
2015-08-24
749 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, 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