Before this post gets started, let’s get past the title. I know what many of you are thinking: what in the name of Paul Randal would make someone have...
2020-03-05 (first published: 2020-02-29)
425 reads
According to this post, I rate 2019 as a Failure. Of the books I planned to read, I read 2. I started 2 others, but they’re in progress, even...
2020-02-28
178 reads
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With more than 15 years of experiences in the field of databases, business warehouses and development,...
2020-02-28
21 reads
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With more than 15 years of experiences in the field of databases, business warehouses and development,...
2020-03-06 (first published: 2020-02-28)
166 reads
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue to make in the product. One item that I found interesting recently was schema filtering....
2020-03-04 (first published: 2020-02-27)
265 reads
By Steve Bolton …………Each group of distance measures surveyed in this segment of the series was defined by affinities between the underlying equations. For example, the common denominator for...
2020-03-04 (first published: 2020-02-27)
307 reads
Midlands PASS (Columbia, SC) will be meeting on March 3, 2020, for our monthly user meeting. We’ve been on hiatus since the holidays but we should be meeting regularly...
2020-02-27
48 reads
There really are technology stacks and business use cases that should never be moved off of big iron. Then there’s the rest of us. Chances are very high if...
2020-03-03 (first published: 2020-02-27)
570 reads
Okay, the title of this blog post could also have been “SUMX returns unexpected results with duplicates”. The results only seem incorrect because an incorrect assumption might have been...
2020-03-02 (first published: 2020-02-27)
493 reads
In celebration of Women’s History Month starting next week, I was asked to write this blog about my experiences as a woman in the SQL Community, and it really...
2020-02-28 (first published: 2020-02-26)
533 reads
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item 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