This is an illustration, not real code. Presumably, you might have lots of other code that checks for the need to rollback.

However, I'm not sure SET and SELECT impact the...

Forgot about the draft, got a mix of decent players, I think. No idea how to judge who to start.

I wish, and we've debated this. There is some caching taking place because some of these summary pages (/forums, /active, etc.) are heavy on the db, so we have a...

I assume you have the same structure locally and are just duplicating this in S3? I haven't tested this, but it looks reasonable. I see your same code on SO...

Hope for the best, plan for the worst. I tend to follow that in most of life.

Closing as duplicate

Looks great, closing this.

Take it. Should be a short, easy one.

As Jeff noted, include TRUNCATE in here.

I'd agree with Sue

There were distributed partitioned views, but these didn't work well, created dependencies and didn't necessarily help performance - https://techcommunity.microsoft.com/t5/datacat/distributed-partitioned-views-federated-databases-lessons/ba-p/304955

Not sure they're still around. You can use a linked server...

+1 for Jeff's advice

Released this back to normal. I don't see anything in there that would...

Unless these are relatively small tables, this is going to be a problem. There isn't a way to do this across tables easily.

You can insert data from a table into...

https://www.mssqltips.com/sqlservertip/2612/data-driven-colored-text-for-reporting-services-reports/