Sql updating multiple tables simultaneously
As often happens with rapid growth and expansion, these environments were in varying states depending on the care and feeding they'd been receiving, and we were helping them get a handle on these environments, standardizing their management and configuration with a variety of tools and best practices.
One piece that sorely needed to be addressed was getting all of the SQL instances (which included databases instances as well as SSRS and SSIS servers) up to a common patch level.
Here is the scenario: I have a table with approximately 15 columns and 60k rows I want to insert the contents of that table into two existing empty tables.
If not, based on the info below, what would you recommend?
You'd also likely not want to do this in a production environment, especially with clustered SQL instances, as there you'd want to deliberately patch the passive node(s), roll the instance and patch the remaining node, instead of the "Blindly apply patch restart" school of updating.
But it did do a great job of simultaneously (and quickly I might add) get a few dozen SQL instances up to a common patch level.
Software and hardware names mentioned on this site are registered trademarks of their respective companies.
Should any right be infringed, it is totally unintentional.