Queueing Theory
There has been tons of work over the last few decades on queueing theory, mainly in regard to operating systems...
2007-08-11
1,681 reads
Engagement
I got a note from someone at Red Gate about disengagement with the newsletter and site. Actually it was my...
2007-08-09
1,417 reads
Table Partioning Article Posted on SSC
Article is at http://www.sqlservercentral.com/columnists/awarren/3135.asp. I'll have quite a few more on this subject over the next few months. As I...
2007-08-09
1,367 reads
Fewer Seats Make for Better User Group Meetings?
We had a visitor from another group at our recent www.opass.org meeting and it was interesting that one bit of...
2007-08-09
1,350 reads
User Groups, Geeks, and Puzzles
Last night we had one of bi-monthly meetings of oPASS (Orlando SQL Servers User Group) and we had a pretty...
2007-08-08
1,447 reads
Dell Laptops, D-Link routers and Cisco VPN
It's not directly SQL Server, but it does prevent me from working with SQL Server 🙂
So I'm in Virginia this...
2007-08-08
2,908 reads
Am I a Good Customer?
Maybe not. This is a great post and cartoon from David Reed (a friend) mentioning me.
We've had some good arguements...
2007-08-07
1,594 reads
Risky Behavior
An interesting debate from one of my editorials on risk. Some great points raised by everyone, but I still think...
2007-08-07
603 reads
Professional Development Plans Article on SSC
This was fun to write. It's a subject I'm passionate about and that too few in our field seem to...
2007-08-07
551 reads
No More SSNS
We've dropped an acronym!
In my rounds of the blogs today, a number of people have pointed out that SQL Server...
2007-08-03
544 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