Developing software taught me to look ahead, anticipate results based on past events and current conditions. This has affected my whole life, but it also drives my wife crazy...

I had to laugh out loud at the Lucid quote. No, this is most definitely not the worst version. Automatic remote firmware updates absolutely can (and do) make things...

There is great potential if it works well. and it can.

If it doesn't,...

There is great potential if it works well. and it can.

If it doesn't,...

For sure, the problem...

Wow, nothing like that. I don't ran lots of that at Virginia Power (now Dominion Energy) and another company. Don't know anyone there, and I know we tossed the 4.2...

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.