September S3OLV
Here is another short reminder about this months UG meeting in Las Vegas.
We will be meeting Thursday at the same...
2010-09-08
504 reads
SQL RNNR
Managing Contacts
This is one of those posts that has little to do with SQL Server and more to do with helping...
2010-09-06
568 reads
September S3OLV Meeting
Another month has crept up upon us. It is time once again for the Las Vegas User Group /PASS Chapter...
2010-09-03
498 reads
SQLSaturday SLC 2010
Well, I have taken another plunge. I finally got around to submitting a session for SQL Saturday Salt Lake City...
2010-09-01
521 reads
Defensive Db Programming Chapter 06
We are here again after another week and ready for another episode in this series. Today we get to talk...
2010-08-30
1,774 reads
Memory
Not a sound from the pavement
Have you ever come across a SQL query that used to run faster? Has that...
2010-08-25
3,484 reads
SSSOLV: Twitter Compliant
This is just a short blast about the Las Vegas User Group called SSSOLV (Web | Twitter). I am not certain...
2010-08-24
509 reads
Sp_whoAmI
I was doing a little catching up on some blog reading today and came across a new post from Adam...
2010-08-24
947 reads
Defensive Db Programming Chapter 05
We are here again with after another week and ready for another episode in this series. Today we get to...
2010-08-24
1,672 reads
Star Struck
Have you ever run into an error and been puzzled as to why that error occurred?
Recently I have been working...
2010-08-17
784 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