Scripting optimization

• Jay Ho

  SSC Enthusiast

  Points: 102

  More actions

  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

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  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

• Jay Ho

  SSC Enthusiast

  Points: 102

  More actions

  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

• philcart

  SSC-Forever

  Points: 47796

  More actions

  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