Marek, can you post the BCP command as you're using it?

And, since you're moving data from SQL Server TO SQL Server, if you use the "Native" data format, it'll absolutely scream.

dean gross (3/4/2008)

---

Andrew Novick's Transact SQL User Defined Function's book has an excellent discussion on Documenation, Formmatting and Naming Conventions in Chapter 6. In this, some of his reasons for...

That's a pretty awesome machine...

I can see it coming... RBAR on steroids... someone's going to make a temp table in the "outer" procedure and then step through it a row or two at a...

I'm all done taking pot shots at a problem that keeps changing... Please, clearly define the...

Are you happy with the performance?

Gary E. Vernon (3/8/2008)

---

Good solution for small Database but not for terrabyte databases. Ours takes 3 days to load from backup. Using partitioning and file groups or snapshot...

I dunno... to me, killing everyone's connection seems to violate a 24x7 SLA. I've used the same method at the table level before without killing any connections with no...

That would be exactly correct... that's why I said "Code is not the only thing to consider where performance is concerned." 😀

By the way... if you're getting these times...

Heh... I can explain that... since it's a "script", it may not be subject to the normal "code release" steps within a company, it's callable from DTS or SSIS, it's...

No... I meant the LIKE thingy you wrote... but, I get it now... and, yes, you must've been bored 😛

Nicely done! Podcast is pretty darned cool, too!

Do what, Barry? Maybe I'm tired but I don't get what you're solving... please explain.

Mo,

Donn's method will do you just fine. If it needs to somehow be automated, let us know.