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.

The hierarchy is that one key encrypts another. So the SMK (service master key) encrypts the DMK and allows it to open. The DMK, once open, allows you to open...

I also wonder how this works with staff turnover. Right now, most of us have met others in our offices and worked with them. What happens over time as we...

Will we continue to work long term WFH? I really don't know. I suspect not, because WFH was never something any employer in my state, allowed before COVID-19. My...

I ran into this and was surprised. The syntax is strange, but what a quick easy way to aggregate.

Why not indeed. This has been a bug with people and SELECT * for a long time.

Essentially, the compilation of the view is the problem. It's like two different programs...