BWAAA-HAAA!!!!  Who said anything about "BE"?  I'm knocking them off and hanging them on the fireplace. 😀

Thanks frederico_fonseca and Jeff Moden for the extensive feedback.

I'm transfering 160 million rows of oracle 11g number (19,0) not null to sql server numeric(19,0) not null

Using SQL 2017 Enterprise...

I'm dealing with a crappy proc, and a crappy design, right now.

The devs did the "Code first" design.  In other words, the ORM designed the database for them.

I...

@aveek22 ,

Man, once again, very well written article.  I just have to seriously disagree with the methods you used.  Please see my previous post above for why.

For what was written as code in the article, I'm wondering the same...

How much memory do you have allocated to SQL Server and how big is the transfer in bytes?  I ask because I've seen this before and it was simply due...

What's the MAXDOP setting for the server?  And what's the Cost Threshold of Parallelism set to?

Enquiring minds want to know... what did you find out?

It sounds like you may have a fair number of indexes on your tables.  Of course, those can make SELECTs absolutely fly.  For INSERTs, that can really slow things down...

ok - nice and simple but can you explain the $escape_none(jobid) bit... this sounds like it is the bit I am looking for - I've never used it. does...

This is an old style of "Equi-Join" that has been replaced by the current "Ansi Standard" joins that most of us use today.  Yes, the join is being done in...

I deal with an older person every day... me! 😀  I can't avoid me even if I turn around wicked quick.  I can also tell you that you shouldn't try...

oh man i wish i was...

I once joked that Hadoop encouraged you to think about new ways of solving data problems. Mainly it encouraged you to think of ways of solving those problems without...

oh man i wish i was in that stream...