With all things containers I refer to my good friend Andrew Pruski. Known as dbafromthecold on twitter he blogs at https://dbafromthecold.com I was reading his latest blog post Using...
2019-03-26
382 reads
It’s important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect. Today I want to look at what...
2019-03-26
60 reads
Watch this week's video on YouTube
It's important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect.
Today I want...
2019-03-26
14 reads
Watch this week's video on YouTube
It's important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect.
Today I want...
2019-03-26
16 reads
OMG! My brain almost blew up. All because of MVP Summit I’ve just returned from. Obviously (due to NDA), I can’t tell you what I’ve seen and found out,...
2019-03-25
7 reads
Learn how to get a list of all Unicode characters to copy and paste, or use in queries / web pages / programs, or search by value, etc.… Continue...
2019-03-25
632 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-03-25
970 reads
This is in response to someone asking about getting started with their database in SQL Source Control and then hosting at BitBucket. I’m going to assume people can set...
2019-03-25
433 reads
I love the questions I get when presenting: Can You Force a Parallel Plan in Query Store. I haven’t a clue. The trick I think is going to be...
2019-03-25
108 reads
Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server ... Continue reading
2019-03-25
34 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