you really need to consider upgrading your SQL to most recent one - 2014 is now on extended support for just another 3 years.

OP is correct in that in SQL...

why is it causing performance issues? and what are those issues?

could it be that instead of splitting the table you may need to partition it (if all your queries use...

you didn't supply all the indexes of the tables - table revision has another index (IDX_Online_Id)

just as a glance I would suggest trying the following changes

Table revision - Index IDX_Online_ID...

and what progresses have you done over the last 2 month on rewriting it yourself based on all pointers given here?

one way of doing it

SELECT f.DMDUNIT, c.PREPACK, c.UPC, c.REPLENTYPE
 
  FROM [FCSTPERFSTATIC] f
  LEFT OUTER JOIN [UDT_CKB_SNAPSHOT] c
  ON f.DMDUNIT=c.PREPACK
  or (c.PREPACK is...

just use straight convert with the correct destination type (e.g. no VARCHAR without specifying a size - bad practice!!) and with the correct format - no need for substring either.

If you don't need the end user connecting as themselves, you could have it connect as a specific user on the remote machine.  Downside is you may need to...

Instantaneous transaction rollback

With...

• This reply was modified 4 years, 9 months ago by frederico_fonseca.

please stop posting the same question on different threads - you have already 4 or 5 on same subject.

keep this on https://www.sqlservercentral.com/forums/topic/inline-table

error message does tell you what to do -

• create a staging table with same structure of the main table, with all required constraints/indexed
• do a partition switch from the...

not enough information to tell you what is the correct way to do for your particular query but the following should point you on the right direction.

select...

sql playing dumb on this case

if your software can be set to do other types of joins/cross applies or even to, as you said, generate the isnull (which works on...

on the server itself (or through xp_cmdshell on that sql instance) execute

tnsping tableau

if the server is names like that you will get an output with the ip/hostname of the server...

very few items from a SQL coding perspective are not available on standard since 2016 SP1 - before yes it was a problem, nowadays not so much unless you are...

and how many cpu/cores/numa nodes does that machine have?