Agree....just remember a few things:

1. Make sure your dimension columns being updated have been defined as Flexible.

2. You may be surprised at how much time this may take as any...

I agree with Phil's approach.

SELECT

EXCEPT

SELECT

is a tried and true way of doing a column specific "table diff". I use hashing as a last resort for extremely large and wide dimensions...

H2 the Izzo!

Is this the predecessor or inspiration for Management Data Warehouse (MDW)?

Tried that too. No good.

I was running SSMS on my laptop as both the laptop admin and the SQL sysadmin when this happened. I even pasted the file path in windows explorer and the...

You are certainly not alone.

Thinking in multidimensional...

I still cannot figure it out, but we used a workaround by creating a SQL Agent Job and having our launching application execute sp_update_job and sp_start_job.

However, I would still LOVE...

"GET IT" AND HAVE THE RESOURCES/SMARTS...........this was a SQL AND....not an OR to be taken out of context. 🙂

The Cardinals and the Red Sox are the only ones that seem to "GET IT" AND HAVE THE RESOURCES/SMARTS available to quickly dig themselves out of an overpayment mistake--and compete/overachieve...

Got it. Thanks.

Although I was not the original topic posting, I guess I may have misinterpreted something. My fault.

Does this query assume the latest identity value is the greatest?

I once had a BI client that reached the highest integer value possible in an identity column. This client...

A Monday morning LOB ball.....a gift from above.

Haha...I THOUGHT you were going to say:

"The fact that you NEEDED 3 phases proves my point."

That's close enough 😉

MS definitely did a decent job of giving you backwards compatibility. We did our migration in three rather painless phases.

1. Co-opt with the main RDBMS migration.....doing the bare minimum conversion...