To my knowledge, the only book specifically on this topic was written back in 2008 or so (looking it up, seems the book got updated in 2012). However,

Oh please. We don't have to list all the times we screwed up do we? My list is going to take a long time to compile. I think I'll have...

Grant - its likely to be Solar EMP rather than Solar Radiation - look up carrington event.

.. and the Sun HAS been behaving in an unpredictable manner this Solar...

Thanks.  Can you comment on Query store, Forced a good plan with query store and left query store on to capture all. So far the server is operating well....

If you're rebuilding the indexes, then don't update the statistics. An index rebuild updates the statistics with a full scan. You don't need to run that after a rebuild.

Wait, are we talking parameters or variables as stated in the original question? They're different and result in differences in estimated row counts.

You've already received the scoop on parameters. The...

Option 2 is probably the way to go. Cross database dependencies are very difficult to deal with in SSDT. I always found I had to do a certain amount of...

Nothing is immediately leaping out. Have you checked the database consistency recently? Anything in your error logs?

Hardware.

Since you're not in any way filtering data, the only solution is great big giant hardware. Spend lots of money and this will go faster.

Now, you could look at possibly...

If a user knows the right login and the right location to use, they can connect with any tool at all.

There's no easy way to deal with what you're asking...

Any time a third party backup tool is introduced to the system, don't rely on anything anyone tells you on the internet. Test a restore. Did it work? Yes? Great....

If you're looking to expand your analytics skills, I'm going to pile on and say R or Python. Great choice.

Otherwise, man, this whole data management, data analysis, etc., business is...

Guessing.

It's SSMS. Someone is using the GUI to edit tables. They're getting warnings and ignoring them.

Please don't cross post the same question across multiple forums. It makes it hard to keep a focused conversation and answer the question efficiently. Please, any additional posts on this...

Be careful of autogrowth here. Also, it's a good idea on any drive with auto-growth enabled, create an file called 'deletemeinemergencies' or similar. Make it big enough, say 20 or...