S3OLV August Meeting II
I recently published a post about the upcoming meeting for S3OLV. This post is to serve as an update to...
2011-08-08
579 reads
SQL RNNR
S3OLV August Meeting II
I recently published a post about the upcoming meeting for S3OLV. This post is to serve as an update to the post. It is quite important that a more...
2011-08-08
11 reads
SSRS Export En Masse
Have you ever found yourself in need of exporting all of the reports from a Report Server? I have found...
2011-08-08
2,552 reads
SSRS Export En Masse
Have you ever found yourself in need of exporting all of the reports from a Report Server? I have found myself in need of extracting all RDLs from a...
2011-08-08
44 reads
Come One Come All S3OLV August 2011
Hey Yo!! We are primed and ready for this month down in Las Vegas. We have a return presenter and...
2011-08-05
573 reads
Come One Come All S3OLV August 2011
Hey Yo!! We are primed and ready for this month down in Las Vegas. We have a return presenter and we are looking to get some speed freak on...
2011-08-05
13 reads
August Meme Monday – Crap Code
Interesting topic this month posted by Thomas LaRock. This month he has chosen “crap code” as the topic. I think...
2011-08-01
792 reads
August Meme Monday – Crap Code
Interesting topic this month posted by Thomas LaRock. This month he has chosen “crap code” as the topic. I think it is interesting because there really are so many...
2011-08-01
14 reads
Activity Monitor and Profiler
Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head...
2011-07-28
2,002 reads
Activity Monitor and Profiler
Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head blocker in a blocking chain. That script can...
2011-07-28
16 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