SQL Server Performance

Tool for Code Review?

Discussion in 'Third Party Tools' started by sachinsamuel, Apr 1, 2008.

  1. sachinsamuel New Member

    Hi All,
    Do we have any tool to do code review for SQL Server 2005 code (Stored procedures, functions, views and TSQL)?.
    A tool which can help in identifying if there is any
    1) Unused variable
    2) unused parameter.
    3) And best practices
    For SQL Server 2000, we have SQL server best practice analyzer. Best practice analyzer for SQL server 2005 is very basic and only checks configuration settings.

    Thanks in advance.
  2. dineshasanka Moderator

  3. sachinsamuel New Member

    Thanks Dineshasanka,
    But SQL refractor is more into formating. I want a tool which can scan through all the objects and prompt if there is any violation.
  4. dineshasanka Moderator

  5. dineshasanka Moderator

    Also there is microsoft best practice analyser. but I doubt it check the variable stuff
  6. satya Moderator

    Also you may find the software spotlight articles on this website that will give you much insight of usage.
  7. Luis Martin Moderator

    What about SQL prompt from Red Gate?
  8. kirtesh_jain New Member

    Hi Sachin,
    Were you able to find any tool to review SQL Server code ..for e.g SQL SP , functions and views...
    Please send me the info because I am also looking for the similar tool.
    Kirtesh Jain
  9. FrankKalis Moderator

    This might be worth investigating: http://www.sql-server-performance.com/software/review/ApexSQL_Enforce_p1.aspx

Share This Page