I like Scott's approach overall, though I dislike temp tables. Sure, they work, but if this fails or gets stopped/interrupted, I like to know where things are.  I'd likely make...

I'm sure you have a lot more wisdom. I feel often that it seems experience goes away, but only in a limited sense. So much of the world doesn't really...

All depends on what the workload is. I might use the view approach, or I might do something differently. Hence why I asked the OP questions.

You have to query every table. However, 1 large view means S locks on lots/all tables as you combine them (potentially). A cursor means fewer locks at once, but serial...

That is definitely a reason to automate

There isn't a great way to do this. The view thing works, but it's still creating a big query. Is this a spur of the moment thing or a regular...

Interesting views. There certainly can be value in studying, or slowing down.

I think as we gain experience, we also get an idea of how much work is involved in automation....

Hopefully a rare occurrence. I think modern hardware sometimes spoils us into thinking it rarely fails, but it still does.

Too many of these philosophies are taken as "exact" by people. DevOps means keep getting better. It's what Toyota did, what Deming did, it's what martial arts has taught for...

I (surprising to me), am not a big graphic fan novel, especially after loving comics, but it's cool that they did this.

Lol, in the context of software, this one is perfect: If you want it real bad, that's frequently the way you'll get it.

Those are great, thanks.

WOW, Steve, I didn't realize that the world is moving in a direction like this. I trust you when you say people (companies) are adopting multiple database platforms that...

WOW, Steve, I didn't realize that the world is moving in a direction like this. I trust you when you say people (companies) are adopting multiple database platforms that...