Partitioning Part 2 Posted on SSC
I'm a couple days late updating the blog, the article went up on Mon.
2007-10-11
580 reads
Blog Posts
Views, Temp Tables, Data Types - Aha!
I spent last week onsite with a client teaching performance tuning and it was really a good week. Great company...
2007-10-08
614 reads
The Contest
I hate contests. I mean it's nice to get people involved and I start out with the best of intentions...
2007-10-07
735 reads
My Book is Out!
How to Cheat at Securing SQL Server 2005
I recently had the opportunity to contribute a couple of chapters to this...
2007-10-04
554 reads
What's In a PodCast - Part 1
Well, lots of mistakes. Here's a good example of one: Friday Oct 5 mistake.
I decided to go the budget route...
2007-10-04
986 reads
Midlands PASS October Meeting
Taya Blanchard to speak on A
Practical Guide to Making Sense of Your SQL Server Application
Performance
Midlands PASS Chapter - October...
2007-10-03
582 reads
Estimates - Part 1
I saw a very interesting post about estimating software from Steve McConnell, of Code Complete fame. He compared his estimate...
2007-10-02
1,023 reads
Paperwork Day
Doing payments for articles, expenses, and a few articles. This is definitely a paperwork day. As much as I like...
2007-10-01
653 reads
Clustered Indexes
I work almost exclusively with third party applications. I don't get to do a lot of tuning except for reports...
2007-09-30
1,300 reads
The Quickest Podcast in the Business
I almost forgot to record the podcast for tomorrow's editorial. In case you're a glutton for punishment, it's here. I'd...
2007-09-30
1,618 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