Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-09-18 : 01:21:49
|
| Dear All,there is one good tool for sql server which works for almost every aspect. the specialty is it automatically re writes the select statements with a good tuning. are there any other tools which will automatically rewrite the queries?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-09-18 : 01:35:44
|
Yes. There is. But it is not cheap. Check out pesoquery or visaexpress. These two covers most of the aspect on SQL Server. For specific area like DBA related, try taradba. Or if you are looking for something with extra punch, try Aikispirit version 1.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-09-18 : 01:43:26
|
One word of warning, don't go for khton. It is a bloatware and weigths a ton if you got what i mean. I have used it personally and had very bad experience with it. It's slow, and most of the time, the rewritten query does not work at all. It required lots of resources and you have to upgrade your PC just to be able to run that. Not to mention the constant installation of add-ins like fodo and bere.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-09-18 : 02:22:22
|
| I'm talking about ordinary tools not extraordinary.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-09-18 : 04:18:29
|
quote:
Originally posted by khtan
Yes. There is. But it is not cheap. Check out pesoquery or visaexpress. These two covers most of the aspect on SQL Server. For specific area like DBA related, try taradba. Or if you are looking for something with extra punch, try Aikispirit version 1.
KH[spoiler]Time is always against us[/spoiler]
now that is funny!  _______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2008-09-18 : 09:09:24
|
| I've been using TOAD for sql server for the past week and it's growing on me. I know it has Query tuning functionality, but I haven't used it yet. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-09-18 : 10:34:48
|
such a tool would be very difficult it not impossible to write. writing good code requires creativity, inspiration, and experience. it's craftsmanship. non-trivial to put that into a program. maybe someday someone will do it and then we'll all have to find other work. 
elsasoft.org |
|
|
|
|
|
|
|
|
query rewrite tools