Viewing 15 posts - 52,441 through 52,455 (of 59,064 total)
It seems to me that the real big difference between a mere table and an array, are the array indicies themselves... You know, the stuff where you can...
February 18, 2008 at 6:03 pm
If there's no confidential info in the file, recommend you attach the file to a post and lets take a peak. Can't really tell, otherwise.
February 18, 2008 at 5:56 pm
Heh... do be a bit careful... my questions, although certainly appropriate, are likely to be taken as a high insult. 😉 I know this because new vendors I try...
February 18, 2008 at 5:54 pm
I'll have to defer to someone else because I always end up using the BCP format file 😀
Hey folks, can anyone else help here? I don't use DTS for...
February 18, 2008 at 5:45 pm
Heh... the method certainly is useful for a lot of things that would otherwise require a cursor... and a heck of a lot faster, too!
Matt, that's perfect... the only thing...
February 18, 2008 at 5:15 pm
A proper format file using BCP will do... dunno if you can do that in DTS without writing some sort of script...
February 18, 2008 at 4:25 pm
Wow... Outstanding job, Matt! Thanks for that!
I'm pretty tickled that one or the other of us can beat the CLR methods pretty much hands down on eveything except RegEx,...
February 18, 2008 at 1:03 pm
The fact that the UDF is taking longer than the embedded code is normal... there's a bit of an overhead associated with running UDF's in many cases especially when the...
February 18, 2008 at 12:51 pm
February 18, 2008 at 12:49 pm
Why? That's as bad a double post. You're just gonna make people mad...
February 18, 2008 at 12:48 pm
Good list, like everyone else said. Just no hair in the list...
I'd first ask them if they've actually tested their code on a 64 bit machine. I'd want...
February 18, 2008 at 12:45 pm
How many times have you run the test? First section of the test caches the data for the second one. Try reversing the two tests and see what...
February 18, 2008 at 12:38 pm
Good stuff, Phil... we had some critical stuff we needed to do as a batch job and, for sure, it required "SA" privs and xp_cmdShell...
I love my DBA... she...
February 18, 2008 at 12:02 pm
Ken Gaul (2/18/2008)
Still can't see why anyone would...
February 18, 2008 at 11:46 am
Although using FSO through sp_OA is a wonderful idea... it still requires "SA" privs. Not complaining or arguing... just reminding 🙂
February 18, 2008 at 11:34 am
Viewing 15 posts - 52,441 through 52,455 (of 59,064 total)