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/

It's likely never going completely away, but we are getting better about writing code to avoid this and detecting it in scans.