I was using LEN() to troubleshoot an issue I was having with a dynamically constructed string truncating while inserting into an NVARCHAR(MAX) column. Since I know that NVARCHAR(MAX) has...
2020-07-22 (first published: 2020-07-14)
1,642 reads
Assumptions
You are familiar with the basics of setting up Go and can run basic Go commands like go build and go install and don’t need much guidance on that...
2020-07-14
393 reads
It’s the second Tuesday of the month and time for T-SQL Tuesday again. This month I’m grateful that Kerry Tyler is hosting. I had the pleasure of sitting with...
2020-07-24 (first published: 2020-07-14)
501 reads
I’ve now been printing surgical mask straps aka “Ear Savers” since April 5th. It has been a wild journey getting started and obtaining all the supplies needed such as...
2020-07-14
12 reads
I’ve now been printing surgical mask straps aka “Ear Savers” since April 5th. It has been a wild journey getting started and obtaining all the supplies needed such as...
2020-07-14
13 reads
Are you a Microsoft SQL Server DBA managing one or more servers? Then you should know about the First Responder Kit from Brent Ozar Unlimited. This is a free...
2020-07-14
350 reads
Defining primary keys is the hardest part of the operation. You will need to work very closely with the business in order to define exactly what column or columns...
2020-07-20 (first published: 2020-07-14)
346 reads
[MSSQLFUN & Decode ITeS becomes a family of 1700 individuals across the globe. Please join us on Facebook & YouTube.] Server Roles: Server roles are security principals to control access of...
2020-07-14
135 reads
One of the tasks that any DBA should know How to take backup to URL or restore a backup from URL and this’s the easiest part very simple steps...
2020-07-14
18 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-14
18 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