I'll leave that one for the DBAs here. Counter Strike is a good call, that will do it!

Also any other backup ideas anyone can throw out for me to try and increase backup times?

I'm sure that there are lots of ways to do that (eg, play Unreal...

Some of your SQL syntax can be refined a little (not that there was anything wrong with yours):

DROP TABLE IF EXISTS #Test2;

CREATE TABLE #Test2
(
   ...

I have one idea I haven't tried yet (think it will work):

(1) import data into temp file

(2) use alter database to add the missing fields if they do not...

As it's a log table, would I be right in thinking that the only items to be replicated would be new INSERTs? Or are there UPDATEs and DELETEs to contend...

Brian, that's a very helpful link, thank you!

Interesting technique too ... I never knew that there was any way round using non-native assemblies in SSIS, other than installing them in...

How is DiscountMeasure calculated?

Jason's solution should run faster, as long as there is never more than a single / in the t1 values.

Just need to switch things round a bit:

            
July 20, 2020 at 8:53 pm
            
#3771537

            
            
                                                
        

Try this:

SELECT t1.*
FROM #Test1 t1
    CROSS APPLY STRING_SPLIT(t1.SName, '/') ss
    JOIN #Test2 t2
        ON...

Infallible, unless the original text contains some combinations of angled brackets, in which case alternative 'dummy characters' may be employed, for example:

SELECT t.SomeString
    ...

There's now a well-known solution to this problem which requires no non-standard functions:

DROP TABLE IF EXISTS #Test;

CREATE TABLE #Test
(
    SomeString VARCHAR(500)
);

INSERT #Test
(
  ...

I think its on my side. My SSMS crashes and restarts. As of now we dont have src control where im at. We're in the process of setting it...

Also, can't you just regenerate the ispac from source control?

Can you tell whether the error is generated locally, or on the server?