A common complaint of database administrators (DBAs) is that performance bottlenecks are not among those problems that one can fix "by just throwing hardware at it." Thus, database servers must provide tools and techniques to help administrators address this issue. On that aspect, SQL Server 2005 does not disappoint.
However, one missing element among the performance tuning services of the new SQL Server is the ability to analyze large amounts of code to detect possible inefficiencies without executing the code. We will discuss an add-on, Code Inspector for SQL, which is a static analysis tool for T-SQL being developed at Siemens Corporate Research. It is intended to help DBAs and developers optimize database performance.
The article continues at http://www.sys-con.com/story/?storyid=46999&DE=1