Viewing 12 posts - 1 through 12 (of 12 total)
most informative... thank to all!! Once my additional hardware is here I'll start the implementation, I'm sure I'll be posting again.
John
December 11, 2003 at 5:27 am
Thanks for all the posts and information. It's been very informative. After more experimenting, the NOT EXISTS runs about 8 times faster on average. Seems the larger the number of...
December 9, 2003 at 8:08 am
Thanks so much Jonathan. The NOT EXISTS worked great... performance probably 10 times faster and now acceptable.
December 8, 2003 at 6:36 am
Are you sure that it is one of the tables causing the problem? I've ran into this many times, but never with a table.
December 8, 2003 at 5:11 am
I had started using them one time in a table and then I realized I couldn't do a 'group by' on a bit field... so I changed them to tinyint....
November 24, 2003 at 6:23 am
Yes, I can use a CASE statement and that's a good idea. The impression I'm getting now is that I need to address the sql update statement(s). When I initially...
November 20, 2003 at 10:34 am
This table is in use 24/7 and dropping the index obviously requires rebuilding the index which in the past takes about 10 minutes and during which time, the view is...
November 20, 2003 at 9:52 am
As hard as I've tried to eliminate the temptable I have not been successful. Couple of things hinder it:
1)the joins become so extensive that performance is killed.
2)sorts on computed...
September 24, 2003 at 10:27 am
Crappy: Thanks for the datetime suggestion. I think there's a saying... sometimes, one can't see the forest....
Mark: this makes sense, I especially like the 'averaging' aspect of it...
September 12, 2003 at 5:49 am
Thanks for all the input. I don't think I expressed my problem very well. Perhaps I should have asked... 'What is the best way to initiate a VB program on...
August 25, 2003 at 5:08 am
I think I found the problem. Seems you cannot use EXEC to work with the data type Table.
I've tried simple examples and it works fine without using EXEC but whenever...
May 7, 2003 at 7:26 am
I found this very interesting as it's a problem I'm facing. Just thought it important to note that in order to use the /3GB swith, you must be running Windows...
March 24, 2003 at 7:24 am
Viewing 12 posts - 1 through 12 (of 12 total)