Viewing 15 posts - 51,961 through 51,975 (of 59,072 total)
Marek, can you post the BCP command as you're using it?
March 10, 2008 at 4:27 am
And, since you're moving data from SQL Server TO SQL Server, if you use the "Native" data format, it'll absolutely scream.
March 10, 2008 at 4:17 am
dean gross (3/4/2008)
March 10, 2008 at 4:15 am
That's a pretty awesome machine...
March 10, 2008 at 4:07 am
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...
March 10, 2008 at 4:03 am
In fact, i am having hundreds of columns in each of nearly eight tables.
I'm all done taking pot shots at a problem that keeps changing... Please, clearly define the...
March 10, 2008 at 3:59 am
Gary E. Vernon (3/8/2008)
March 9, 2008 at 9:13 am
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...
March 9, 2008 at 9:10 am
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...
March 9, 2008 at 8:50 am
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...
March 9, 2008 at 8:44 am
No... I meant the LIKE thingy you wrote... but, I get it now... and, yes, you must've been bored 😛
March 8, 2008 at 9:08 pm
Do what, Barry? Maybe I'm tired but I don't get what you're solving... please explain.
March 8, 2008 at 7:51 pm
Mo,
Donn's method will do you just fine. If it needs to somehow be automated, let us know.
March 8, 2008 at 7:42 pm
Viewing 15 posts - 51,961 through 51,975 (of 59,072 total)