PL/SQL implies Oracle (or PostgreSQL). Are you using Oracle or Microsoft SQL Server 2016?

If you're looping one-row-at-a-time, don't -- there's a lot of latency and extra logging costs in row-by-agonizing-row...

SQL is a relatively simple language. I think your domain knowledge in healthcare would certainly be an asset as a data analyst in healthcare.

How are your technical skills/confidence/experience in general?...

Do you know how to get execution plans? Do you know how to interpret them?

You can generate an execution plan in SSMS if you click the "Include Actual Execution Plan"...

In SSMS, you can right click on the server & select properties, then select Memory. You should set memory to something lower than total server memory so that sufficient memory...

Statistics are what the query optimizer uses to choose an execution plan.They contain statistical information about the distribution of values. The Query Optimizer uses these statistics to estimate the cardinality,...

What edition of SQL Server? Hopefully not Express, as it can't take advantage of all that horsepower.

Compare actual execution plans.

You might try updating statistics on the new computer.

You have more...

SQL Server Management Studio is a separate install: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

But your original query isn't querying  sys.objects on the linked server, it's querying it on the server trying to use that linked server remotely.

If those tables you need in sys.objects...

If print didn't return anything, that tells you you're getting a null when concatenating. Since you're only concatenating obj.name, that seems to imply that the following returns nothing in the...

Assuming dbo.BC_Data_Capture_Staging exists in the database in which you execute this statement:

1. Comment out or remove the INSERT lines so you are just selecting & debug:

   1. print instead of executing

   ...

https://dotnet.microsoft.com/en-us/download/dotnet-framework/net35-sp1

https://docs.microsoft.com/en-us/dotnet/framework/install/dotnet-35-windows?WT.mc_id=dotnet-35129-website

SQL Server doesn't support the CREATE TABLE as SELECT syntax.

You either explicitly create and then insert, or use SELECT INTO -- e.g.,

SELECT ID, Rail_Road, NCS_Codeline, NCS_Subdivision
INTO Codelines_backup 
FROM...

I have seen temporary shortages of specific instance configurations in specific regions, but It seems odd that AWS couldn't supply the EC2 instances you need in the long run. Are...

"else 0"

Try changing 0 (zero) to '0' or some other string

Sure, it could happen.