Posts
Sort by recent activity
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_...
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...
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...
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...
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.
SQL Prompt can't preserve my custom snippets folder setting
I'm using the most recent version of SQL Prompt. I also use a custom snippet folder. Each time I start SSMS, SQL Prompt changed my previous set custom snippet folder to its default value. Please he...
How to create user defined actions like this?
How to create user defined actions like this?