S3OLV April Change
Earlier this week I announced the meeting for the Las Vegas User Group. I blasted some of you with emails...
2011-04-07
489 reads
SQL RNNR
S3OLV April Change
Earlier this week I announced the meeting for the Las Vegas User Group. I blasted some of you with emails – along with people in our mailing list. Those...
2011-04-07
9 reads
S3OLV April 2011
Are you ready to learn again? The Las Vegas SQL Users Group is ready to have our April meeting. The...
2011-04-05
544 reads
S3OLV April 2011
Are you ready to learn again? The Las Vegas SQL Users Group is ready to have our April meeting. The meeting is to be held April 14, 2011 at...
2011-04-05
8 reads
SQL Server Role Membership
How well do you know the security in your SQL instances? Do you know who has sysadmin level permissions? SQL...
2011-04-05
816 reads
SQL Server Role Membership
How well do you know the security in your SQL instances? Do you know who has sysadmin level permissions? SQL Server provides a few methods for you to find...
2011-04-05
33 reads
Indexing Just Got Easy
As a database professional one of the things that we should be familiar with is the use of indexes. In...
2011-04-01
668 reads
Indexing Just Got Easy
As a database professional one of the things that we should be familiar with is the use of indexes. In SQL Server an index helps to improve query performance...
2011-04-01
15 reads
PASS Subcommittee
In February I posted this post about the need for Volunteers for SUMMIT 2011. I submitted my application to volunteer....
2011-03-31
1,547 reads
PASS Subcommittee
In February I posted this post about the need for Volunteers for SUMMIT 2011. I submitted my application to volunteer. This past week I got word back concerning that...
2011-03-31
8 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