Comments
Sort by recent activity
Hi Jim
Thanks for posting. You’re absolutely right and moving the $CURSOR$ placeholder as you suggested will fix the issue. We’ll make this change to the default 'curff' snippet in the product for future releases.
Thanks
Ali / comments
Hi Jim
Thanks for posting. You’re absolutely right and moving the $CURSOR$ placeholder as you suggested will fix the issue. We’ll make this change to the default 'curff' snippet in the product ...
Hi
You can attempt to free up some memory by clearing out SQL Prompt’s cache. To do this, uncheck Enable Suggestions in the SQL Prompt menu (or pressing Ctrl+Shift+P) then enable them again using the same option (or pressing Ctrl+Shift+P again).
SSMS’s native Intellisense also uses a fair bit of memory. You could try disabling it completely by going to Tools > Options > Text Editor > Transact-SQL and unchecking the Enable Intellisense checkbox.
Tab history does store its data to disk so that should not be affecting memory usage. However, if you have a lot of tabs open at once, closing some of them should also free up some memory.
Thanks
Ali / comments
Hi
You can attempt to free up some memory by clearing out SQL Prompt’s cache. To do this, uncheck Enable Suggestions in the SQL Prompt menu (or pressing Ctrl+Shift+P) then enable them again using...
Hi Tim
Unfortunately there is no setting to increase the amount of memory available to SQL Prompt. The problem is that SSMS is a 32 bit process and as SQL Prompt is an add-in for SSMS, SQL Prompt must share its memory space with SSMS.
You might be able to improve this behaviour by uninstalling any other add-ins you have for SSMS.
You can also manage which databases SQL Prompt connects to, more details here: https://documentation.red-gate.com/display/SP7/Managing+connections+and+memory
By excluding connections to the large database (or excluding connections to other databases if you still want suggestions for the large database), you’ll free up some memory.
We do have some plans to work around these memory constraints in future, but this work won’t be started for a while.
Thanks
Alasdair / comments
Hi Tim
Unfortunately there is no setting to increase the amount of memory available to SQL Prompt. The problem is that SSMS is a 32 bit process and as SQL Prompt is an add-in for SSMS, SQL Prompt m...
Hi
You can stop snippets being suggested by replacing the default snippets folder with an empty folder.
To do this, inside SSMS or VS go to SQL Prompt > Snippet Manager then change the path of the snippets folder to any empty folder (I just created a new folder at the same level as the default 'Snippets' folder, called 'NoSnippets' and used that).
Thanks
Ali / comments
Hi
You can stop snippets being suggested by replacing the default snippets folder with an empty folder.
To do this, inside SSMS or VS go to SQL Prompt > Snippet Manager then change the path of the ...
Hi
I just reread your question and realised you were probably talking about the actions list popup rather than snippet suggestions.
It is possible to disable the actions list, there are instructions in this thread for how to do that here.
We are considering exposing this option in the UI in future. The downside to disabling it is that you'll lose some functionality that only exists in the actions lists such as "add quotes and commas" and "unformat".
Thanks
Ali / comments
Hi
I just reread your question and realised you were probably talking about the actions list popup rather than snippet suggestions.
It is possible to disable the actions list, there are instruction...
Hi Roland
If the slowdown was caused by the number of tabs in your history then clearing them out like you did was the best approach available at the minute.
We’re going to look into improving this situation. One possibility is optimising the search functionality.
Another is to include an option that automatically deletes tabs that are over a certain age (tabs older one month, for example). Does that sound like it’d work for you?
Thanks
Ali / comments
Hi Roland
If the slowdown was caused by the number of tabs in your history then clearing them out like you did was the best approach available at the minute.
We’re going to look into improving th...
Hi
We think we've got a fix for this issue in this private build, please could you give it a try and let us know how you get on.
Thanks
Ali / comments
Hi
We think we've got a fix for this issue in this private build, please could you give it a try and let us know how you get on.
Thanks
Ali
Hi John
Thanks for raising this, we can reproduce it so we’ll start working on a fix now.
You can work around this temporarily by going into SQL Prompt > Options > Format > Actions and unticking “Add/remove square bracketsâ€.
Thanks
Ali / comments
Hi John
Thanks for raising this, we can reproduce it so we’ll start working on a fix now.
You can work around this temporarily by going into SQL Prompt > Options > Format > Actions and unticking ...
Hi
We can reproduce the Ctrl + click issue so we’ll start looking into fix.
We haven’t seen the Ctrl+C, Ctrl+V weirdness you mentioned. Could explain this a bit more?
If you want to turn off the popup, you can by edit the xml file under %localappdata%Red GateSQL Prompt 7RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml and setting <EnableSurroundWithPopup> to False.
Thanks
Ali / comments
Hi
We can reproduce the Ctrl + click issue so we’ll start looking into fix.
We haven’t seen the Ctrl+C, Ctrl+V weirdness you mentioned. Could explain this a bit more?
If you want to turn off th...
Hi
We think we've got a fix for this issue in this private build, please could you give it a try and let us know how you get on.
Thanks
Ali / comments
Hi
We think we've got a fix for this issue in this private build, please could you give it a try and let us know how you get on.
Thanks
Ali