Post reply

Scripting optimization

  • October 11, 2005 at 4:25 am

    #166312

    Hi all,

    I'm looking for some scripts or some tools that have the ability to check SQL scripts and stored procedures if they are written in a optimized way? Is there such tools or scripts out there? Please help.

    Thanks in advance,

    Jay

  • October 11, 2005 at 4:38 pm

    #596679

    These tools are common in the industry.  They are commonly referred to as SQL DBAs and SQL Developers.  Highly qualified ones can produce optimal SQL after taking a small amount of time to learn the data structure, business rules, etc. 

    FYI:  They like to be paid well, which means you will need to shell out a pretty penny to get these tools in house.

     



    A.J.
    DBA with an attitude

  • October 12, 2005 at 1:09 am

    #596718

    Thanks A.J.!

    We do have these "tools" in house and they are doing a good job I think, but I also need some other tools to check the quality of work from these "tools", if you know what I meant, but these tools I'm looking for don't have to be some D.B.A or developers.

    Any suggestion is appreciated!

    Many thanks,

    Jay

  • October 12, 2005 at 6:03 am

    #596764

    Have a look at the Best Practices Analyzer over at Microsoft.

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply