S3OLV August Recap
The SQL Server Society of Las Vegas meeting has come and gone once again. This meeting is held typically on...
2010-08-16
450 reads
SQL RNNR
TSQL Tuesday 009 Roundup
T-SQL Tuesday #009: Beach Time
I hope you enjoyed your time in the sun with your toes in the sand. We...
2010-08-13
799 reads
Defensive Db Programming Chapter 04
This week we will be checking out the fourth chapter of this book by Alex. This is a continuous effort...
2010-08-11
758 reads
R & R
It is once again time for the blog party known as TSQL Tuesday. I am hosting this month and wanted...
2010-08-10
625 reads
August SSSOLV Reminder
Just another reminder about the Las Vegas User Group meeting coming up on August 12th.
Here is the info:
The S3OLV UG...
2010-08-10
482 reads
August S3OLV UG Meeting
It is nearly UG meeting time once again. The S3OLV UG will be meeting Thursday August 12 at 6:00. Come...
2010-08-04
492 reads
TSQL Tuesday Coming Up
The next TSQL Tuesday is only 1 week away. This month the topic covers getting a little R&R. We would...
2010-08-03
446 reads
Defensive Db Programming Chapter 03
Chapter 3 of the Defensive Database Programming Book by Alex Kuznetsov teaches us about how to “survive” changes to database...
2010-07-26
1,675 reads
5 down 4 to go
Not much ado about SQL Server here. Good things come with the number 9. For instance SQL Server got substantially...
2010-07-23
526 reads
A little Dance with SSIS and Informix
Not too many moons ago I embarked on porting some servers over from SQL 2000 to SQL 2008. On some...
2010-07-23
1,581 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