Viewing 15 posts - 51,751 through 51,765 (of 59,072 total)
Heh... I think the OP "left the building".
The other thing is, ( I don't think anyone mentioned this above) you will never get the same speed using SELECT * no...
March 15, 2008 at 10:43 am
Jack Corbett (3/15/2008)
Steve Jones - Editor (3/15/2008)
I've added this to the list. turns out to be a switch 🙂Sounds like good data-driven design to me:P
I gotta agree there...
... but...
March 15, 2008 at 10:38 am
Oh yeah... almost forgot... I recommend that you don't actually use keywords for column names...
March 15, 2008 at 10:34 am
Jack beat me to it but I'll post my solution anyway... the reason is that I want you to see an example of how to post information about a table...
March 15, 2008 at 10:32 am
Bob Fazio (3/15/2008)
Boy was that cough medicine strong :sick:I never thought of a computer as heavy machinery 😉
😀 Man, thanks for having a good sense of humor. I've...
March 15, 2008 at 9:59 am
mukundbtech (3/13/2008)
Thank u .. and like to know is there any other option other than using a format file .. if so help me
Rethinking this, DTS would probably be the...
March 15, 2008 at 12:45 am
Greg Snidow (3/14/2008)
March 15, 2008 at 12:43 am
halifaxdal (3/14/2008)
Thank you Jeff.
You bet... thank you for the feedback.
March 15, 2008 at 12:36 am
Before you use any of those that have a self join or correlated subquery that use the ">=" or "<=" or any other inequality method to generate row numbers, you...
March 15, 2008 at 12:31 am
Bob Fazio (3/14/2008)
March 15, 2008 at 12:11 am
Bob Fazio (3/14/2008)
Pat Reiter (3/14/2008)
Examples use CHAR(9), but compare to string of format '###-##-####' . Are the dashes not part of the string?
The example was wrong. It should...
March 15, 2008 at 12:02 am
p.s. All the times, scan, and read counts for my previous post were on SQL Server 2k... the optimizer in 2k5 was a little more kind to the...
March 14, 2008 at 11:55 pm
Hey, before I get started on this, "thank you" to all of the folks that took time to provide
some feedback, whether it was pro or con. That's what...
March 14, 2008 at 11:44 pm
Heh... although I'd like to take credit for it, I think that was when they were having date problems on the forum. And thanks for the compliment.
March 14, 2008 at 5:55 pm
Forget the cursors, forget the LIKEs... and remember that ISNUMERIC treats "-", and a whole bunch of other characters as valid numeric characters. NEVER use ISNUMBER as IsAllDigits because...
March 14, 2008 at 3:50 pm
Viewing 15 posts - 51,751 through 51,765 (of 59,072 total)