Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • RE: Log shipping Questions

    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

  • RE: Alternative to NOT IN

    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...

  • RE: Alternative to NOT IN

    Thanks so much Jonathan. The NOT EXISTS worked great... performance probably 10 times faster and now acceptable.

  • RE: Indexed View

    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.

  • RE: Using the bit datatype

    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....

  • RE: Updating a table

    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...

  • RE: Updating a table

    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...

  • RE: Calling SP from within SP

    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...

  • RE: SP execution time

    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...

  • RE: Initiate a program

    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...

  • RE: Table data type

    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...

  • RE: AWE Memory Question

    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...

Viewing 12 posts - 1 through 12 (of 12 total)