Backup script skipping databases – and the fix!
A real head-scratcher
I’ve been using my RYO Maintenance scripts for a little while now, and they’ve been working great. Almost....
2012-04-02 (first published: 2012-03-26)
1,951 reads
Stress Thoughts–Part 1
If I had to tell you that one thing I’ve gotten better at in the past 5 years it would...
2012-03-26
722 reads
Execution Plan for a User Defined Function
When you execute a multi-statement user-defined function you may see an execution plan that looks something like this:
It appears as...
2012-03-30 (first published: 2012-03-26)
8,343 reads
SQLSAT107
I was recently selected to speak at SQL Saturday 107 in Houston TX. I am really excited to be selected...
2012-03-26
548 reads
Slides & Samples from my SQLSaturday #105 presentation about Advanced SQL Server Troubleshooting
As I have announced in my session last Saturday in Dublin, you can find here the
slides & samples for download.
Thanks...
2012-03-26
874 reads
Building the Enterprise DW/BI System with SQL Server PDW
Building the Enterprise DW/BI System with SQL Server PDW
Most readers considering a Parallel Data Warehouse already have a data warehouse...
2012-03-25
4,422 reads
Start Building Your Next Network
Take a look at your network right now and while it probably has some diversity, I bet it’s tied pretty...
2012-03-30 (first published: 2012-03-25)
1,558 reads
Google Research
Interesting to see someone talking about all the research Google is spending money on, which aren’t directly related to their...
2012-03-23
1,284 reads
Trim Functions in SSIS
In T-SQL there are many functions there to help do a variety of different things. SSIS is no different. In...
2012-03-23
2,020 reads
Re-blog – March 16 – March 22
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-23
787 reads
Blogs
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