database tuning engine problem

Question

database tuning engine problem

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

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

AhTu_SQL2k+ Ten Centuries Points: 1012 More actions · Answer 1

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!

Jeff Moden SSC Guru Points: 1004329 More actions · Answer 2

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)

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 3

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