By Steve Bolton
…………In the last series of mistutorials I published in this amateur SQL Server blog, the outlier detection methods...
2015-10-21 (first published: 2015-10-17)
2,525 reads
To celebrate a recent achievement, I have decided to create a whole new section to my blog that will be...
2015-10-17
522 reads
This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much on the forums and there are different recommendations...
2015-10-16
16 reads
This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much on the forums and there are different recommendations...
2015-10-16
21 reads
This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much...
2015-10-16
205 reads
I am proud to be offering several training opportunities at the upcoming PASS Summit in Seattle, WA during the week...
2015-10-16
594 reads
Making Foolish Decisions In WOxPod!, episode # 020– “A Foolish Decision” I announce a foolish decision I recently made, and how...
2015-10-16
461 reads
This post is for the MAXDOP option - how to set it in a SQL Server instance. The option is discussed much...
2015-10-16
883 reads
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-10-16
506 reads
In this article, I introduce the topic of reading session data from memory along with some of the pitfalls and some words of caution.
Related Posts:
How to: File Target use...
2015-10-16
27 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