apps that can identify poor writing query or table joins

Question

apps that can identify poor writing query or table joins

Mad-Dog

SSCertifiable

Points: 6117
More actions
March 28, 2019 at 9:11 am

#2033884

Hi,
do you know about some app (free or paid) that can take a query and check against the databases if it is writing bad or the joins in the tables are not optimized
and recommend changes in the query?
THX

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

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

crow1969 Hall of Fame Points: 3001 More actions · Answer 1

You can try SQL Prompt from Red-Gate. It may not be able to tell you if joins are not optimized, but it should be able to tell you if you have some bad practices in your code.

https://www.red-gate.com/products/sql-development/sql-prompt/

Grant Fritchey SSC Guru Points: 398881 More actions · Answer 2

I work for Redgate, so I'm VERY biased, however...

I agree with @crow1969. It's not the exact solution you're looking for. It only catches certain code smells, but it does tell you when there are issues and suggests fixes.

There really aren't many choices in this area for tools that do better or more. That's experience talking, not bias.

"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

jonathan.crawford SSCertifiable Points: 6612 More actions · Answer 3

I don't work for RedGate, but I have used SQLPrompt, so I am VERY biased. Use SQL Prompt.

-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses