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.

I'm not aware of any TSQL functions, since it involves nslookup, telnet &  SMTP EHLO commands. You can certainly do email address syntax validation in TSQL, but that doesn't guarantee...

The error is telling you the problem -- all the columns used in a foreign key must be all the columns in a unique index on the primary table. If...

If it's only that combination we want to exclude, I think we'd want

SELECT ...

FROM t

WHERE NOT (EMPLOYEE_ID = 123 AND WORKSITE_ID = 22)

(EMPLOYEE_ID != 123 AND WORKSITE_ID...