If you're getting deadlocks from the process, I'd double check the query tuning first of all, the indexing next, and the calls made by the queries. If it's the same...

They're both defined locally. The Recovery Time Objective is how long it takes to recover your database. You have to test it. Recover just a database. Recover a database plus...

I am absolutely not seeing similar behavior. Uninstall and reinstall maybe?

I'm with Jeff, first thought, it depends.
However, I'll go a little farther. With low levels of data modification, even if the computed columns are doing a lot of work,...

Partitioned views and traditional partitioning are not supported because Azure SQL Database implements the PaaS offering differently. However, lots of people do logical partitioning with Azure SQL Database letting the...

Only concern I have is that looks like a big transaction. Will there be multiple copies of this running at the same time? If so, you could see a lot...

Lots of information there. I'll try to make some suggestions.

First, instead of copying all the data every time there's a promotion from one state to another, I'd rather...

Without seeing the query and the execution plan, I can do more than offer vague platitudes.

So, here's one. A  primary key is a unique index. How can replacing...

Why all the group by statements when you're not doing any aggregation that I can see? That's going to blow performance out of the water. Especially grouping on, what, 14...

There are tiny differences in the estimates, but the plan hash and the query hash are identical. To all intents & purposes, they're the same plans. I saw some implicit...