Comments
Sort by recent activity
DustinM said:
Hello, Thank you for your inquiry into SQL Prompt, we are sorry to hear it is giving you trouble. Would you be able to upgrade to SQL Prompt 10.12.3? There have been some SSMS performance fixes that targeted snippets that may help with the slowness/lag. Best, Dustin
Thank you for your suggestion! It works! / comments
DustinM said:
Hello,Thank you for your inquiry into SQL Prompt, we are sorry to hear it is giving you trouble.Would you be able to upgrade to SQL Prompt 10.12.3? There have been some SSMS per...
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 ...
Higgins said:
They came out with 10.6.2. There are still problems. I am unable to type anything with suggestions enabled. I could have 2 lines of SQL code typed on the keyboard before the screen finishes typing out the word "Select". I am on SSMS 18.8 on a Win 10 HP ZBook laptop with 32 GB of RAM. I reverted to 10.5 using the link posted in the thread above.
I tried the most recently version SQLPrompt_10.6.7.19129 as of today, but the issue still exists. SQLPrompt_10.5.6.17542 works fine here. Also note that SQLPrompt_10.5.6.17542 uses the old syntax of snippets and later versions use the new syntax and your snippets will automatically be converted to the new syntax. In that case, if you want to rollback, there is no easy way to convert the snippets to the old format. So keep a copy of your snippets before upgrade. / comments
Higgins said:
They came out with 10.6.2. There are still problems. I am unable to type anything with suggestions enabled. I could have 2 lines of SQL code typed on the keyboard before the scr...
Thanks James. / comments
Thanks James.
Do you have a custom snippets folder?
Yes. It's a shared folder: \\vmware-host\Shared Folders\Snippets
Most of the time I'm working in a VMware Workstation Virtual machine. The snippets folder is a shared folder in the host machine (not the virtual machine). So in SQL Prompt in the VM, I just use \\vmware-host\Shared Folders\Snippets to reference the shared folder.
Where do the snippets not appear? In the snippets manager or just the suggestions box?
The snippets do not appear in both snippets manager and the suggestions box.
/ comments
Do you have a custom snippets folder?
Yes. It's a shared folder: \\vmware-host\Shared Folders\Snippets
Most of the time I'm working in a VMware Workstation Virtual machine. The snippets folder is...
Hi Jessica,
Thanks for your reply. I set the snippet folder from the SQL Prompt Options. I also checked the registry you mentioned, its value is the save as the one I set from the Option UI. The folder IS a bit special. I'm using SSMS with SQL Prompt in a VMware Workstation virtual machine. I shared a folder from the host computer to the guest as z:\scripts. Then in the guest, I use this folder as my Snippet Folder. When I changed the snippet folder to a normal local folder in the virtual machine, it can persist. Could you give me some suggestions?
Thanks. / comments
Hi Jessica,
Thanks for your reply. I set the snippet folder from the SQL Prompt Options. I also checked the registry you mentioned, its value is the save as the one I set from the Option UI. The fo...
Yes it was checked. When I disable the new formatting, I can format the code correctly and it was formatted to: DECLARE @orders TABLE
(
order_id BIGINT NOT NULL
UNIQUE WITH ( IGNORE_DUP_KEY = ON )
);
When I switch back to new formatting, it still format the code as I mentioned before. / comments
Yes it was checked. When I disable the new formatting, I can format the code correctly and it was formatted to:DECLARE @orders TABLE
(
order_id BIGINT NOT NULL
UNIQU...
Hi harryf,
Thanks for taking time to answer my questions. I tried your formatting files. These three formatting files produce the following output. INSERT INTO dbo.dept
(id, name)
VALUES
(1,
N'Administration'
),
(2, N'Sale'),
(3, N'HR');
INSERT INTO dbo.dept
(id, name)
VALUES
(1,
N'Administration'
),
(2, N'Sale'),
(3, N'HR');
INSERT INTO dbo.dept
(
id, name
)
VALUES
(
1,
N'Administration'
),
(
2, N'Sale'
),
(
3, N'HR'
);
Note they are not exactly the same as I requested. The
1, N'Administration'
are always on separate lines. Why they are on separate lines while others are on the same line?
Regards. / comments
Hi harryf,
Thanks for taking time to answer my questions. I tried your formatting files. These three formatting files produce the following output.INSERT INTO dbo.dept
(id, name)
VALUES
(1,...
I hope it can be formatted to this: INSERT INTO dbo.dept
(id, name)
VALUES
(1, N'Administration'),
(2, N'Sale'),
(3, N'HR');
Or at least this: INSERT INTO dbo.dept
(id, name)
VALUES
(1, N'Administration'),
(2, N'Sale'),
(3, N'HR');
or this: INSERT INTO dbo.dept
(
id, name
)
VALUES
(
1, N'Administration'
),
(
2, N'Sale'
),
(
3, N'HR'
);
I didn't test throughly and I just happen to found this issue. Thanks harryf. / comments
I hope it can be formatted to this:INSERT INTO dbo.dept
(id, name)
VALUES
(1, N'Administration'),
(2, N'Sale'),
(3, N'HR');
Or at least this:INSERT INTO dbo.dept
(id, name)
VALUES...
Tdoctor828 wrote:
My thoughts are the same...
The code are much longer now...
How to fix ?
I have no idea. I hope one of the RedGate support can help me on it. / comments
Tdoctor828 wrote:
My thoughts are the same...
The code are much longer now...
How to fix ?
I have no idea. I hope one of the RedGate support can help me on it.