May 22, 2003 at 8:57 am
Are there any Code Review tools available for T-SQL?
Regards.
May 22, 2003 at 10:05 am
None I'm aware of. Are you looking for something to review T-SQL code?
Steve Jones
May 22, 2003 at 11:12 pm
Yes. I am looking a tool that can review T-SQL code based on the given criteria or atleast can check some common performance problem, excessive joins and excessive use of cusrsors.
What about CAST SQL-Builder. Anybody used it?(http://www.castsoftware.com)?
Regards.
May 22, 2003 at 11:47 pm
I came across a tool that could recommend different ways to execute a given query. It would test the options for there relative speeds and highlight those that were faster than your original query.
While writing this I was checking for the product. SQLExpert by Leccotech http://www.leccotech.com
good luck
May 23, 2003 at 7:20 am
Have not tried CAST, pretty expensive as I recall.
Andy
May 26, 2003 at 3:11 am
Thanx all for ur replies.
We will hopefully be starting evaluting SQLExpert and SQLBuilder this week.
Regards.
January 24, 2012 at 11:29 am
You should take a look at DIAB from DIABSQLSoftware.com Integrated into there SQL Monitoring package they have included SQL Code check. It can parse small to large blocks of code and identify problems like needed indexes, table scans, clustered index scans, code best practices, and security issues like imbedded grant statements. Inexpensive to.
February 2, 2012 at 5:57 am
Also check out SQL Cop. I wrote a review of it here[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply