By Steve Bolton
…………“The shortest distance between two points is a straight line.”
…………In this famous remark, Archimedes[1] (287-212 B.C.) managed to...
2018-12-20 (first published: 2018-11-30)
2,561 reads
Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this first post...
2018-12-14 (first published: 2018-11-29)
3,612 reads
The last 2018 edition of SQL in the City Streamed is coming in a few weeks. You can register today...
2018-11-29
355 reads
Kendra wrote a nice piece on this the other day, and I agree.
Take the Survey
The data that comes out...
2018-11-29
339 reads
Not only will you encounter some interesting stories, but I believe you will also encounter some interesting insight into some of the contributors for this book: Data Professionals at...
2018-11-29
10 reads
Working as a Data Professional
An old friend Malathi Mahadevan (b | t) asked me one day if I would be interested...
2018-11-29
252 reads
Every language handles null equality differently and understanding this is crucial as a misunderstanding here can lead to some quite...
2018-12-14 (first published: 2018-11-29)
3,234 reads
Matt (blog | twitter) is preparing for his first SQL Saturday presentation next weekend in Washington, DC. He’s asked:
I wanted to get an idea of some good, bad, and...
2018-11-29
22 reads
SQL Server 2019 brings a very exciting new feature that, is long overdue. Resumable online index create is one of...
2018-12-13 (first published: 2018-11-28)
2,269 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-17 (first published: 2018-11-28)
2,861 reads
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item Let's Talk Certifications
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