SSW SQL Auditor

SQL Auditor is a part of the range of database tools designed by SSW to help to check best practice standards and optimize SQL Server performance.
It also has wizards that generate SQL scripts to correct common problems.

It was developed to assist in performance tuning in SQL Server 7/2000/2005/2008 by performing a SQL Server audits on your database. It allows developers to check their database design against common SQL Server design rules and report on the elements that do not conform to those rules.