I think I read the same page as you did, based on the query you posted. It indicates that the problem is that the amount of memory available for locks...

• This reply was modified 3 years, 1 month ago by  Ed B.

It sounds like you only want to use the guid to join to new contacts in the on-prem table. Is there anything in the on-prem table that tells you it...

If you only care about users' first subscriptions, can you assign a number of days until first subscription to every user?

Then assign each user an offset code (D1, D30, D90,...

You could probably use TRIGGER_NESTLEVEL to do that.

I tend to use session context values instead, set via sys.sp_set_session_context and SESSION_CONTEXT(N'<key_name>').  If you want more info on this method, let...

I don't think you need a function to split the table. I think you need to work with your data to create two tables, shifts and events, containing start and...

Does this behavior occur only with upgraded packages? Or does it affect all connections made using the new oracle source? even in a new project created in SSDT 2019?

Yes! I forgot that the query was inside brackets.

Can you tell whether it loaded all 16K files?

It sounds like it did all the work, but never reported to the screen that it had finished. Did you look at...

You will need an alias for the derived table containing the unions.

Just add "AS a" after the final close bracket/parenthesis. (Ironically the TIA from your message would probably have sufficed).

Without...

• This reply was modified 3 years, 2 months ago by  Ed B.

Can you join to the other tables within the Merge statement so you have access to your codes?

This might be easier to implement as a CTE, but I don't like...

• This reply was modified 5 years ago by  Ed B.
• This reply was modified 5 years ago by  Ed B.

I don't think you will be able to do it in a single query.

Here's how I would approach it. This is fairly vague, but the details will depend on the...

Can you put a check constraint on both tables, e.g. ID <= 100. This can give you a "partitioned view". It works for =, but I have never tried it...

I had to do this last week. I found this forum thread and it gave me what I needed.

http://www.sqlservercentral.com/Forums/Topic1465444-279-1.aspx

SMALLDATETIME gets you closer to what you want.

I think the excel connector relies on MS Office drivers being installed.

https://msdn.microsoft.com/en-us/library/cc280527.aspx