Distinct Count in Analysis Services
Business users are often interested in finding distinct counts in addition to other aggregations. They may want to know the...
2012-03-14
1,273 reads
Looking for a DBA? Looking for a New Job?
Ryan Recruiter meet Dave DBA…
As a contractor and consultant I get to speak to many agents and recruiters and over...
2012-03-14
721 reads
Error 0xC0014062: Unable to complete login process due to delay in opening server connection
Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets...
2012-03-14
7,308 reads
SQL Lunch Rescheduled
Due to a few scheduling conflicts the SQL Lunch scheduled for tomorrow as been rescheduled. The event will be on March...
2012-03-14
806 reads
SQL Lunch Rescheduled
Due to a few scheduling conflicts the SQL Lunch scheduled for tomorrow as been rescheduled. The event will be on...
2012-03-14
660 reads
A Quick Introduction to Data Compression in SQL Server 2008
There is one thing every DBA knows with certainty, and that is that databases grow with time. MDFs grow, backups...
2012-03-13
2,022 reads
T-SQL Tuesday #028 – Is it really specialization?
This is the first time I've participated in T-SQL Tuesday - I hope to do so more often...
I can recall several...
2012-03-13
1,029 reads
T-SQL Tuesday #028 – Jack of All Trades, Master of None?
Another month and another opportunity to write about an interesting topic. This month hosting TSQL Tuesday is Argenis Fernandez (Blog | Twitter). This month, Argenis has invited us to...
2012-03-13
8 reads
T-SQL Tuesday #028 – Jack of All Trades, Master of None?
Another month and another opportunity to write about an interesting topic. This month hosting TSQL Tuesday is Argenis Fernandez (Blog...
2012-03-13
872 reads
Houston Area SQL Server User Group Presentation
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG.
Here is the PowerPoint presentation: Scaling SQL...
2012-03-13
721 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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