Pragmatic Works Seeking Employment Candidates
If you’re anything like me, you enjoy constantly striving to new levels of knowledge. This new level of knowledge brings...
2010-12-18
430 reads
SQL Server 2005 SP4 Released
Steve Jones mentioned recently that SP4 for SQL Server 2005 is on its way because Microsoft closed his connect item....
2010-12-18
524 reads
Just in time for Christmas – SQL Server 2005 SP4
Just in time for Christmas, Microsoft releases SQL Server 2005 SP4.
Many were wondering if they would meet their intended...
2010-12-18
1,761 reads
Let it Snow, Let it Snow, Let it Snow!
I don’t usually post on my blog on the weekend, but this weekend, the weekend before a Christmas is a...
2010-12-18
490 reads
Grant permission to the profile
The Profiler is a powerful tool available to the dba, but it can also be very useful for system developers....
2010-12-18
794 reads
Social Leadership And The SQL Community
2010 is rapidly coming to a close and in retrospect this has been a fantastic year of growth for the...
2010-12-17
1,192 reads
SAC in SQL 2008 (R2)
SAC (Surface Are Configuration) was the great possibility to configure the SQL Server 2005, so there were some options to...
2010-12-17
1,499 reads
How not to ask for help
you can help me for the visule studio 2005 programe I have assigment
I do not how to use for...
2010-12-17
728 reads
Unusual BBQ
Recently some friends invited me to try a BBQ place that they enjoyed, so I went along hoping for the...
2010-12-17
600 reads
The Bar Where Everyone Queries Your Name?
Sent by a friend (yes, it’s a mild fake), but still, shouldn’t someone open a SQL bar or coffee place?
2010-12-17
589 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