Comments
Sort by recent activity
@Jon_Kirkwood The View Actual and View Estimated Plan windows display truncated SQL and as a result selecting the Copy button only copies partial SQL text / comments
@Jon_Kirkwood The View Actual and View Estimated Plan windows display truncated SQL and as a result selecting the Copy button only copies partial SQL text
Ben_P said:
HI@Sanjiv, Thank you for your post. It sounds like you might be referring to SQL Prompts SQL Code Analysis function: https://documentation.red-gate.com/sp/sql-code-analysis
Hi @Ben_P, It might have been this tool however the tool used to have an option to run all it's analyis on the entire database and come back with a list of recommendations. I don't see an option to run the analysis across the database. https://share.cleanshot.com/nnWLP1MP It seems more like prompting for hints and suggestions as you trying SQL in the SQL Editor. Any suggestions? For example which action can I take to scan the entire database and report on missing keys on Foreign Keys among other things? Thanks, Sanjiv / comments
Ben_P said:
HI@Sanjiv, Thank you for your post.It sounds like you might be referring to SQL Prompts SQL Code Analysis function:https://documentation.red-gate.com/sp/sql-code-analysis
Hi @Be...
SQL Prompts SQL Code Analysis function seems to work only with SQL in an editor, it does not scan the entire database for issues like I mentioned. Really wish I was able to track down the tool I used for this. / comments
SQL Prompts SQL Code Analysis function seems to work only with SQL in an editor, it does not scan the entire database for issues like I mentioned. Really wish I was able to track down the tool I us...
aha, I see the option "Show List of Code Analysis Issues..." but it's disabled. Any idea why? [image] [image] [image] https://share.cleanshot.com/DqhL0jR7 / comments
aha, I see the option "Show List of Code Analysis Issues..." but it's disabled. Any idea why?https://share.cleanshot.com/DqhL0jR7