Comments
Sort by recent activity
Hi basilisk,
You can see what the Find Invalid Objects operation is doing by using the SQL Server Profiler. This should show you the object it's looking at when the pause happens.
Regards,
Paul / comments
Hi basilisk,
You can see what the Find Invalid Objects operation is doing by using the SQL Server Profiler. This should show you the object it's looking at when the pause happens.
Regards,
Paul
I've not seen SQL Prompt progressively slowing down across several SSMS sessions before. There isn't anything like a disk-based cache that would explain this.
Are there particular queries that make SQL Prompt go slow when they are opened in SSMS? Would you be willing to share your queries with us?
Thanks,
Paul / comments
I've not seen SQL Prompt progressively slowing down across several SSMS sessions before. There isn't anything like a disk-based cache that would explain this.
Are there particular queries that mak...
Hi rtrujill,
When you say it worked for about a week, is this in a single instance of SSMS that is never shut down? After it breaks, does it work again if you shut down and restart SSMS?
I'm wondering whether your slowdown is related to a resource leak of some kind.
Regards,
Paul / comments
Hi rtrujill,
When you say it worked for about a week, is this in a single instance of SSMS that is never shut down? After it breaks, does it work again if you shut down and restart SSMS?
I'm wonde...
That sort of slowdown seems extreme. Would one of you share your SQL batch with us? It's possible there's a particular construct SQL Prompt doesn't cope with very well, like we found with CTEs in version 5.0.
Please send it to support@red-gate.com if you're willing.
Thanks,
Paul / comments
That sort of slowdown seems extreme. Would one of you share your SQL batch with us? It's possible there's a particular construct SQL Prompt doesn't cope with very well, like we found with CTEs in...
Hi PDinCA,
Thanks for your report. I've logged this in our system as SP-3861.
Regards,
Paul / comments
Hi PDinCA,
Thanks for your report. I've logged this in our system as SP-3861.
Regards,
Paul
Hi Dan,
I've tried reproducing this by creating the AvailableForPurchase table, but I only see each column once in the suggestions list, as expected.
I tried creating the table in both the current database, and also (since you referred to it as Aggregation.dbo.AvailableForPurchase) in a different database, but with the same results.
Would it be possible for you to post full reproduction steps, starting with an empty database?
Regards,
Paul / comments
Hi Dan,
I've tried reproducing this by creating the AvailableForPurchase table, but I only see each column once in the suggestions list, as expected.
I tried creating the table in both the current ...
Hi JP7,
Slow startup times can be caused by the Check for Updates mechanism not managing to reach our server. Please try going to the SQL Prompt 5 menu and choosing Check for Updates... Then uncheck the box in the bottom-left corner called Check for updates on startup.
Please post here whether this has helped or not.
We are tweaking the Check for Updates mechanism in SQL Prompt 5.1 so that even if your machine can't reach our server easily, it still doesn't slow down the startup of SSMS.
Cheers,
Paul / comments
Hi JP7,
Slow startup times can be caused by the Check for Updates mechanism not managing to reach our server. Please try going to the SQL Prompt 5 menu and choosing Check for Updates... Then unch...
Do you have SSMS Tools Pack installed as well? This has a SQL Snippets option, which by default has "D" as a snippet for DELETE, "CRT" for CREATE TABLE, and Enter as the snippet insertion key.
If this is the case then you can disable SSMS Tools Pack's snippets at SSMS Tools > SQL Snippets > Options....
Regards,
Paul / comments
Do you have SSMS Tools Pack installed as well? This has a SQL Snippets option, which by default has "D" as a snippet for DELETE, "CRT" for CREATE TABLE, and Enter as the snippet insertion key.
If t...
Hi shuff,
SQL Prompt looks for extended properties of objects so that it can display the full creation script in the popup window. It also uses the MS_Description extended property to display in the tooltip when you hover over an object's name.
If your user doesn't have permission to see the sysproperties table, then SQL Prompt 5 can't get hold of this information. Unfortunately this doesn't currently fail very gracefully, as you have noticed. It didn't work in SQL Prompt 4 either, but it failed silently rather than triggering the new error-reporting mechanism, and there weren't any other noticeable negative effects apart from incomplete creation scripts.
Thanks to users like you sending reports through to Red Gate, we can see that a number of you are experiencing this issue, which is logged in our system as SP-3549. This raises its priority and we hope to address it sometime soon.
Regards,
Paul / comments
Hi shuff,
SQL Prompt looks for extended properties of objects so that it can display the full creation script in the popup window. It also uses the MS_Description extended property to display in t...
Yes, we did discover after the release of SQL Prompt 5.0 that CTEs do make SQL Prompt perform very slowly. The developers have now produced a fix, which will be included in SQL Prompt 5.1.
I understand that doing CTE-intensive work is very difficult with the current version, so we've also backported the fix to SQL Prompt 5.0. It hasn’t been fully regression-tested, so we’re only telling people who have told us they’ve experienced this specific issue.
Please email me at paul.stephenson@red-gate.com if you're having problems with slow CTEs and I'll send you the link.
Regards,
Paul / comments
Yes, we did discover after the release of SQL Prompt 5.0 that CTEs do make SQL Prompt perform very slowly. The developers have now produced a fix, which will be included in SQL Prompt 5.1.
I unders...