Do a BCP out to a file and have Oracle import it (I can't remember the name of the built in tool on the Oracle side).  The last time...

It would also be beneficial if you provided the execution plan from 2014 and the execution plan from 2017.  The comparison will probably show that the 2017 version is much...

Correct - we don't have a DR node at this time...but it would be easy to add another node to the cluster and build out an AG for all databases.

You...

Not sure I understand the new configuration you are looking at - but having an FCI and an AG in the same cluster does work.  You cannot have 2 clusters...

If your deletes are setup in smaller batches - with a wait in between each iteration, then it shouldn't impact the users to any large degree.  SQL Server will manage...

If the requirement is to be able to open the attachment in Excel - then a simple CSV output file should open up by default in Excel.  That can be...

How exactly is the parameter being used in the code?  That is the missing piece here...

Why would it change?  Because you upgraded from 2012 - and there was a significant...

If the parameter can be blank or null - you can modify the update query to this:

UPDATE t
SET FirstName = coalesce(nullif(@first_name, ''), FirstName), 
   ...

If @Parm is defined as varchar(nn) - then try changing the value in the code to @Parm = '1' instead.  The ideal solution is to make sure the parameter definition...

I use a free product call Terminals - you can find it on GitHub.  I cannot access the site from work - so I cannot provide the link.

Create the indexes as you need them in SQL Server.  You can then disable the NC indexes prior to loading the data - and rebuild the indexes after the data...

Your query has SUM - which requires a GROUP BY and that is missing.

your DB server should be in a DMZ (dead mans zone/demilitarised zone) which is effectively 2 firewalls

but if you want to allow client access to your data then you...

I posted a function that calculates the 4-5-4, 5-4-4 and 4-4-5 calendars for a 3 year period here: https://www.sqlservercentral.com/scripts/fiscal-retail-4-5-4-calendar-function

If I am understanding your request - you need to figure out...

Not enough information - and not real sure what problem you are encountering.  Is there an error?  How are you calling this stored procedure?  Where does the stored procedure live?

If...