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

Are there additional joins in this query that could also be affecting the number of rows returning? It does sound like it's a bit of a mess. Best of luck...

No matter what, you have to query the database (unless you export the data), so there has to be either an AD login or SQL login that can run the...

All these calculations on columns

SUBSTRING(InvoiceNumberMapping, 2, 7) =