How can we help you today? How can we help you today?
ogrishman

Activity overview

Latest activity by ogrishman

Is it possible to align a subquery with other items?
I have a piece of SQL.SELECT *FROM sys.dm_db_index_physical_stats(         DB_ID(),         OBJECT_ID(N'Sales.SalesOrderDetail'),     (SELECT CAST(index_id AS INT)FROM sys.indexes WHERE name = 'IX_...
1 follower 1 comment 0 votes
SQL Prompt is so slow when I have 255 snippets
I'm using SQL Prompt Version 10.12.1.28146 with SSMS v18.12.1, and I have 255 snippets. When I disabled SQL Prompt suggestion, I can type freely in SSMS and it's very smoothly. But when I enabled S...
2 followers 3 comments 0 votes
Higgins said: Between my last post on this thread (Feb 22) and now I had a support ticket open with Red Gate. The support people learned that an issue exists in 10.6+ if your snippets reside on a network share or UNC path with high latency between your computer and the network location (think working from home via VPN). If you set your snippets folder to a local path on your computer like C:\MyFolder\RedGateSnippets then there is no issue with performance. To @ogrishman's point, I have observed the conversion of snippets from XML to JSON and their software creates a backup for you in the Snippet path so your "old format" XML snippets should be in a subfolder called "backup" of your snippet folder's path but as always it is best to create your own backup. Quote from my support ticket... "I have spoken with our dev team about this. You have clearly highlighted a need for improvements around the performance of SQL Prompt v6 when referencing network shares, however unfortunately, given current workloads and overall impact of this issue, at this stage we cannot say when we will be able to address this. For the time being, as a workaround we suggest using a local folder for your snippets instead of a network drive with high latency when working from home over a VPN. Alternatively you could continue to use SQL Prompt 10.5 for now." I'm using the default snippet location and have the performance issue. In your case if you use a local folder as the snippets folder, do you have the performance issue? / comments
Higgins said: Between my last post on this thread (Feb 22) and now I had a support ticket open with Red Gate. The support people learned that an issue exists in 10.6+ if your snippets reside ...
0 votes
How can I convert the new snippet format to old?
I've updated SQL Prompt to SQLPrompt_10.6.7.19129 and I have performance issue, which should be the same to https://forum.red-gate.com/discussion/87783/sql-prompt-version-10-6-0-17688-slow-cursor-m...
1 follower 1 comment 0 votes
Using SQL Prompt with two SSMS instances
I normally need to open multiple instances of SSMS. I found when I add a snippet in the first SSMS, it didn't show up in the second SSMS. If I add another snippet from the second SSMS, it didn't sh...
2 followers 6 comments 0 votes
How to escape $ character in a snippet?
How can I output something like $tablename$ literally in SQL Prompt? I tried to use back slash or double $ to escape $ but failed. Thanks.
1 follower 1 comment 0 votes