Viewing 15 posts - 56,236 through 56,250 (of 59,067 total)
| or more likely you are simply asking for more than 10-20% of the total data in the set... |
June 1, 2007 at 5:33 pm
Nicely done... still going to take a fair bit more than that if table has more than 1 DateTime column, has no DateTime column, or, as you said, has different...
June 1, 2007 at 5:27 pm
Very cool... nice job, Antonio... takes only 28 seconds on the million row test...
June 1, 2007 at 4:47 pm
1. Don't use anything but SQLCHAR when importing text files.
2. Don't use anything but "" for coalation on non-character based columns.
June 1, 2007 at 4:28 pm
Heh... thanks Chris. And, nice job, by the way ![]()
But... try this... one less join = faster performance
June 1, 2007 at 4:14 pm
Dinendra,
The question remains... what are you doing where you think it might be a good idea to find a way to sort without using ORDER BY?
June 1, 2007 at 3:37 pm
David,
Here's an attempt to explain the "errors" that creep in... same "error" bit me big time... Lynn pointed it out to me and Serqiy gave me the tool that explained...
June 1, 2007 at 7:42 am
Hey folks... I screwed up
way back when and I've crossed out my posts about this because they were wrong... what I saw...
May 31, 2007 at 11:13 pm
Crud... there goes the neighborhood
Just kiddin' guys... but cut it out, please.
Serqiy, ran the query you posted you were absolutely correct on...
May 31, 2007 at 10:59 pm
With a fair amount of dynamic SQL... ![]()
Do you mean you want to do an "auto discovery" of each table having any DateTime column...
May 31, 2007 at 10:28 pm
Antonio,
Heh... had to do a double take... but no... it's working correctly because of the DISTINCT transfer and the GROUP BY... here's the results with the original data and your data...
May 31, 2007 at 10:23 pm
| Jeff, I got to understand your code, but found a bug in it. Using your short test table, if... |
May 31, 2007 at 10:01 pm
Probably, Serqiy.... just I think they did it at a machine language level which would be a lot faster the at the "T-SQL Level".
Heh... I agree about the OO hints......
May 31, 2007 at 9:55 pm
Yeah... and it get's worse... check it out... didn't use to work this way... ![]()
select str(612.005, 10, 2) UNION ALL
select str(612.015, 10, 2) UNION...
May 31, 2007 at 9:48 pm
Viewing 15 posts - 56,236 through 56,250 (of 59,067 total)