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...

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...

Savepoints and conditional transactions

This is the second in a short series on transactions. In the previous part I discussed nested transactions and showed...

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...

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...

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...

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...

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...

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...

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...