You also have to be aware of transaction log usage - if you import a large file in a single batch you will need at least that much space available...

You probably need to rethink the approach...

What is the agent job doing?  Why does it need to run after this process - and why does it need to run in...

As long as your cluster maintains quorum - the AG will continue to function and you won't have any issues, that is why you have the file share witness.

For a...

I would recommend starting with these two parts of the query:

AND cf.TableName = REPLACE(REPLACE(fm.DestTable, 'Holding_', ''), 'HoldingTable_', '')

LTRIM(RTRIM(ISNULL(CAST(im.NewValue AS VARCHAR(MAX)), ''))) <> ''

The first one doesn't make...

I don't see any code that was uploaded - it looks like one of your posts was marked as spam.

I have no idea what

It won't load all...

I don't see any code that was uploaded - it looks like one of your posts was marked as spam.

I have no idea what

It won't load all of the...

These kinds of issues is one reason I do not recommend auto-patching and restarting clusters of any kind.  These should always be manually patched and restarted to ensure that quorum...

I have built an SSIS package to load the NPI data - the only issue I had was the size.  To handle that I compressed the table...

The process is simple...truncate...

If what you really want/need is EXCEPT - then put that in a CTE to get the valid list of items, then select from the CTE and join in any...

I don't see why the variables would be a problem. They can be dumped with PRINT and SELECT as well. No reason to replace them with something else to...

These are not the...

Can you show us the name you see in that database?

Before even going down this road - what is the purpose of copying data from database B into database A?  What issue are you trying to resolve by doing this?

Unless...

• This reply was modified 5 years, 8 months ago by Jeffrey Williams.

A temporary stored procedure is created the same way a temporary table is created - it is a temporary object available for that connection and located in tempdb.

When the connection...

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/t-sql/functions/patindex-transact-sql?view=sql-server-ver15

Did you even try my solutions?  The second one definitely works as you expect...

Select *
   From @testTable tt
  Where tt.TestValue Like '%PQ5|1|%^^^^%';

And if you...