Code review tools for SQL 2005

[gaya3]

Hi All,

Is there any free SQL code review tools to check the quality of the SQL code and to improve the performance?

[Rabbit]

It already comes with a couple. In the Query menu in management studio, you can view the execution plans and/or analyze the query in the database engine tuning advisor.

[gaya3]

Thanks for your reply. I tried a sample sql to tune in Database Tuning Advisor. But whenever i start the analysis after loading the workload file, i got error while submitting configuration information. Only then i came to know that, to use the Database engine tuning advisor we require the Database Admin rights, which would not be available for developers. Could you share any tools that can be used by developers to tune the SQL queries?

[Rabbit]

Well, if you don't have permissions to use the database tuning advisor, did you try the execution plan tool?