That cannot happen just because of a network outage - if the configuration was altered and the cluster removed, it was because someone removed it.

I would bet something else is...

The first question I have is - what issue are you trying to resolve by rebuilding the indexes on this table?

If the answer has anything to do with performance -...

I am surprised that no one else answered the original question - and this just evolved into using temp tables and trying to solve the performance issue using a temp...

Linked servers have several problems - one of the biggest is that SQL Server will often pass the query to the other system with incorrect parameters.

We just ran into this...

Better be careful here - if that is a datetime and not datetime2 or date...

the way it is done, on many companies, is to restore the DB on a PROD server (can be same server as the source if server has the required...

How - and why - are you deploying from SQL Server to SQL Server?

Instead of trying to extract from SQL Server using SSMS - build the project in VS -...

Just curious - but you stated you are using SSIS, but here you are using a stored procedure to execute a BULK INSERT?

I have to ask why you decided not...

FWIW - it isn't necessary to set or change the protection level because deploying to the catalog is going to change it anyways.

See here: https://andyleonard.blog/2018/04/deploying-to-the-ssis-catalog-changes-the-protection-level/

And here: https://learn.microsoft.com/en-us/sql/integration-services/security/access-control-for-sensitive-data-in-packages?view=sql-server-ver16

Once you...

fair enough, I was being flippant and referring to other free plugins. I looked again and the redgate toolkit is 1300, not 1500. I wouldn't consider that significantly less...

No - that is not an option for an availability group.  It would also negate the HA requirements - since anything with a lag would no longer satisfy high availability.

Is the ID column the clustered index?  If not - then you should change the delete so it is deleting in clustered index order.  But - as others have already...

I would have the Oracle DBA's try to kill the process on their side first.

Without actually seeing a specific workflow or a more specific example - I would have to say that making any changes to the agent job is the problem.  If a...

That extra 14-bytes will be added only when the row is...