You don't need this:

ALTER DATABASE MyDatabase

SET ALLOW_SNAPSHOT_ISOLATION ON

That's a different kind of snapshot isolation that is controlled by each connection and transaction. Read_Committed_Snapshot should be sufficient. You're probably best setting...

Not to my knowledge. But then, I haven't had to use it.

Nice attempt at your first blog post.

Unfortunately, there are a few questionable suggestions in there.

For example, what's the difference between these two queries:

SELECT * FROM Sales.SalesOrderHeader AS soh

LEFT JOIN Sales.SalesOrderDetail...

I'd set up an extended event session and include causality tracking. I'll bet this is part of some extended transaction and just evidencing the deadlock in a funny way.

The Repeatable Read isolation level is much more restrictive, holding locks until a transaction is committed so that others cannot modify data, so yeah, that's absolutely going to lead to...

That's weird. What's the isolation level on the connections do you know?

Sorry I don't have better info. This one looks really odd.

Nice job on the PR.

Yeah, those discrepancies can make you nuts. I usually don't even attempt to resolve them and just say "This one is different than that one" and keep going. Makes my...

Hey Jared!

I'm not sure. Are these statements part of a larger batch? Do you have triggers on the system? How about CDC or Audit? It seems like something other than...

Unless you're operating in a development environment, I wouldn't suggest even using STATISTICS IO. I've actually noticed it negatively impacting queries. Instead I capture events using extended events (you can...

When all inserts, updates and deletes return an error and the data being transmitted gets lost, most people consider that pretty dire.

Ummmmm....

No.

NoSQL used to mean, no gol darned Ess Que Ell because we hate the DBAs and we hate the language and we just want to go FAST FAST FAST and...

You absolutely can. Create a backup device and then backup to it. It can be a tape. But, understand, going directly to tape is much slower which could have all...

You should set up domain accounts. That's the preferred mechanism of managing SQL Server anyway.

Deadlocks are always about performance. The faster an update occurs, the less likelihood of deadlocks. So, first things first, make sure that your updates are performing well. Are they doing...

it could be due to index fragmentation from updates or inserts within the cluster. Moving the data all at once leads to less fragmentation, which would explain the differences in...