SSSOL July 2011 Reminder
This is just a quick note to remind anybody who may be interested of the upcoming Las Vegas User Group...
2011-07-13
606 reads
SQL RNNR
SSSOL July 2011 Reminder
This is just a quick note to remind anybody who may be interested of the upcoming Las Vegas User Group meeting. As I posted here, we will be learning...
2011-07-13
12 reads
Foreign Key Hierarchy Update
Today I would like to revisit a post of mine that is rather old. More precisely, the script in that...
2011-07-11
1,066 reads
Foreign Key Hierarchy Update
Today I would like to revisit a post of mine that is rather old. More precisely, the script in that post needs revisiting. This is one of my more...
2011-07-11
9 reads
Meme Monday – Horoscope
Did you know that your sign may have changed? I didn’t – at least not until reading the meme Monday announcement....
2011-07-11
494 reads
Meme Monday – Horoscope
Did you know that your sign may have changed? I didn’t – at least not until reading the meme Monday announcement. Most people probably will see no difference in...
2011-07-11
9 reads
July 2011 S3OLV Meeting
We have had a bit of a lag between meetings for the User Group of Las Vegas. In June, a...
2011-07-06
490 reads
July 2011 S3OLV Meeting
We have had a bit of a lag between meetings for the User Group of Las Vegas. In June, a meeting was scheduled but did not happen. The cause...
2011-07-06
9 reads
Lessons from Out of the Blue
This past Fourth of July weekend I had the opportunity to do a few different things and thought I would...
2011-07-06
733 reads
Lessons from Out of the Blue
This past Fourth of July weekend I had the opportunity to do a few different things and thought I would share some experiences. None of these experiences were job...
2011-07-06
12 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