Advice I Like: Ranch Rules
Leave a gate behind you the way you first found it. – from Excellent Advice for Living This is a ranch rule. Leave something as you found it. If...
2026-02-06 (first published: 2026-01-30)
292 reads
Leave a gate behind you the way you first found it. – from Excellent Advice for Living This is a ranch rule. Leave something as you found it. If...
2026-02-06 (first published: 2026-01-30)
292 reads
This is part of a look back at the history of SQL Server Central as a part of our 25-year celebration in Feb 2026. "They want how much?" That was a question I got from Andy one afternoon as we discussed how we were going to manage the growth of SQL Server Central. I had […]
2026-02-06
2,461 reads
2026-02-06
530 reads
2026-02-06
165 reads
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
2026-02-05 (first published: 2001-07-04)
9,092 reads
Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.
2026-02-05 (first published: 2004-03-25)
9,163 reads
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
2026-02-05 (first published: 2002-04-04)
7,768 reads
2026-02-04
1,172 reads
Adding non-core database features to a system can expand its capabilities, but it can also be an expensive use of your hardware and software licenses.
2026-02-04
140 reads
2026-02-04 (first published: 2026-02-03)
145 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