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 |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2006-12-20 : 11:53:11
|
| Hello,Is there a tool to optimize SQL procedures code?Thanks,Miguel |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-12-20 : 12:03:40
|
| Other than the best one which is between your ears....I don't think so. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-20 : 12:23:58
|
The Index Wizard may be of some help.Other than that there are methods of seeing the decisions that SQL Server makes in deciding on how to make a given query, and from those you can decide that rubbish query plans  can be improved by rewriting the query, adding indexes, and so forth.Kristen |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-12-20 : 14:20:18
|
| I have found the best optimization tools to be:PesoMVJKristenBrettMooseand a LOT of the others around here [Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-20 : 14:23:09
|
As long as we talk about FREE tools, yes  Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
SQL Optimization