Post reply

database tuning engine problem

  • June 24, 2008 at 9:01 pm

    #833674

    Well, I do agree with all of your opinions. Simply and blindly follow DTA's suggestion could be negative move sometime.

    But at least, it is an useful tool for some reasons that MS wants to provide in the package and I personally found it is an useful tool in SQL2000.

    That's why I am trying to scratch my head to make it work and I had tried to install to 2 other pc but result were the same.

    Appreciate your opinions given to my post and should anyone found a solution just please let me know.

    Thank you.

    Together, we can make wonders!

  • June 24, 2008 at 9:06 pm

    #833677

    Yeah... I guess we strayed quite a bit. Sorry...

    I've never seen that type of problem occur... If I do and I can actually fix it, I'll try to find this thread and post the answer.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • December 10, 2008 at 11:49 am

    #910585

    regarding your timeout error i can only guess that your query is taking too long to execute...i had the same problem for some other purpose..you can increase the timeout duration by going to the tools in database engine..default i think is 30secs..u can change it and may be then try...but this is just a gues..thanks..

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply