Activity overview
Latest activity by Sanjiv
Number of rows returned by query
Hi,Is it possible to view the number of row returned by a query? Tools like Dynatace, XRebel, New Relic are able to display this and it's extremely useful in identifying queries that are selecting ...
@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
long SQL text truncated
Is there a limit to the SQL length size displayed in SQL Monitor? I'm noticing it's truncating text over 4k and I want access to the full SQL in cases where such log SQL commands are issued. Is the...
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
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...
SSMS Plugin that analyzes the database
Hi,It's been a couple of years that I used Red Gate. I remember there was a RedGate tool that was a SSMS plugin that did an analysis of the database and reported issues on table fields types, missi...