Finding the relationship of a filegroup and a partition
The other day, I was trying to find out which partition is on which filegroup for a a partitioned table....
2007-12-12
1,611 reads
Blog Posts
Driving Debate
I write a daily editorial, which is one of the reasons that I don't post here as often as I'd...
2007-12-11
1,406 reads
Managing Funds for User Groups
This question seems to come up a lot and it's worth discussing. Few user groups are incorporated, fewer still are...
2007-12-11
652 reads
Disappearance
Wow, it's been a long time since I posted here. I actually had to search for my name to find...
2007-12-10
670 reads
Podcasting
A new video setup is on the way!!!!
Actually I'll do a couple podcasts on podcasting over the holidays here since...
2007-12-10
3,052 reads
How do you make a Wiki work?
Following up on my post about Wikipedia, I read an article in Eweek, 25 Tips for a Better Wiki Deployment...
2007-12-09
642 reads
Contributing to Wikipedia
Recently I posted about an interview with Jimmy Wales and only a couple days after that I ran across What...
2007-12-06
596 reads
Tribute to Honor Jim Gray
Saw this on the Association for Computer Machinery SIGMOD announcements.
Tribute to Honor Jim Gray
It is scheduled for May 31, 2008...
2007-12-05
566 reads
How Will Processor Licensing Evolve?
Information week had an interesting article that talks about the different methods of licensing used, ranging from the what we're...
2007-12-04
658 reads
Powerpoint from a Blackberry
Ran across the Impactica Showmate, a $249 item (gadget?) that allows you to present Powerpoint presentations wirelessly via Bluetooth directly...
2007-12-04
656 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
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