When naming transactions causes an error
For the last part of the series on transactions, I’m going to look at a problem that I ran across...
2015-12-21 (first published: 2015-12-15)
2,574 reads
SQL In The Wild
Why would you want to name a transaction?
Something that i keep seeing in documentation, in forum code and in real systems is transactions that have names
BEGIN TRANSACTION...
2015-12-04 (first published: 2015-12-01)
5,875 reads
Savepoints and conditional transactions
This is the second in a short series on transactions. In the previous part I discussed nested transactions and showed...
2015-11-20 (first published: 2015-11-17)
3,417 reads
A Mess of Nested Transactions
Transactions are an area that I often find are used badly, or not used at all. Transactions without any error...
2015-11-03
858 reads
Of clustered indexes and ordering
There is a particularly irritating and persistent belief that indexes (usually it’s the clustered that gets picked on) are always...
2015-10-26 (first published: 2015-10-20)
2,837 reads
Index selectivity and index scans
There was a question raised some time back ‘If an index is not selective, will the query operators that use...
2015-10-14 (first published: 2015-10-06)
4,422 reads
Repairing a replication subscriber
It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes...
2015-09-22
1,141 reads
Unusual errors with Distributed Replay
I’ve come to really like Distributed Replay in the last couple of years. I’ve used it to do a scale...
2015-09-08
1,177 reads
How not to do a Masters degree
There are many, many guides to successfully completing a post grad degree, so I am not going to add to...
2015-08-11
603 reads
It's not you; it's us
Mirrored from http://www.sqlservercentral.com/articles/Editorial/101894/
By now I expect this news is no longer new: the MCM, MSA, and renamed versions of those...
2013-09-04
2,076 reads
Blogs
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
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