The Roundup for T-SQL Tuesday #192
Last week I asked you to write about SQL Server 2025 and what things you might be looking forward to in the new version. First, as usual, is Rob...
2025-11-18
151 reads
Last week I asked you to write about SQL Server 2025 and what things you might be looking forward to in the new version. First, as usual, is Rob...
2025-11-18
151 reads
AI can help us do more, but do we need to do more? Or more importantly, are we doing a good job of producing more useful stuff?
2025-11-17
204 reads
2025-11-17
671 reads
2025-11-15
133 reads
Do you take the time to model and design your database? Steve thinks this is important, even while trying to make changes quicker to adapt to changing requirements.
2025-11-14
167 reads
2025-11-14
723 reads
Like many of you, I have often put strings together (concatenation) with a simple arithmetical operator: +. We have a few other ways to put strings together, but in SQL Server 2025, we have a new operator that allows us to put strings together. This is the double pipe (||) operator. This article looks at […]
2025-11-14
3,884 reads
2025-11-12
583 reads
How do you approach adding to your team? Steve asks if you look internally or externally as a default.
2025-11-12
95 reads
One of the language changes in SQL Server 2025 that I’ve seen a lot of people mention is the addition of RegEx functions to T-SQL. I decided to take...
2025-11-12
166 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