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.
    Regards
    Sachin
    sachinsamuel, Apr 1, 2008
    #2

  2. dineshasanka Moderator

    dineshasanka, Apr 1, 2008
    #3

  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.
    Regards
    Sachin
    sachinsamuel, Apr 1, 2008
    #4

  4. dineshasanka Moderator

    dineshasanka, Apr 1, 2008
    #5

  5. dineshasanka Moderator

    Also there is microsoft best practice analyser. but I doubt it check the variable stuff
    dineshasanka, Apr 1, 2008
    #6

  6. satya Moderator

    Also you may find the software spotlight articles on this website that will give you much insight of usage.
    satya, Apr 1, 2008
    #7

  7. Luis Martin Moderator

    What about SQL prompt from Red Gate?
    Luis Martin, Apr 1, 2008
    #8

  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.
    Regards,
    Kirtesh Jain
    kirtesh_jain, May 23, 2008
    #9

  9. FrankKalis Moderator

    This might be worth investigating: http://www.sql-server-performance.com/software/review/ApexSQL_Enforce_p1.aspx
    FrankKalis, May 23, 2008
    #10

Share This Page