powershell_ise is a good enough debugger - may need to be installed on pc as its not always ticked by default.

close all your visual studio instances - if that does not work restart your pc and do the install then - without opening VS again!!

for me it would mean using TDE as this is encryption at rest for all I know - I would ask whoever requested it to ensure that is what they...

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

when you build you sql string just make sure to replace any single quote with two single quotes - that will solve the issue with SQL while keeping the data...

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, 7 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...