Comments
Sort by recent activity
Can you upload your formatting file? Is that what you mean by style sheet? / comments
Can you upload your formatting file? Is that what you mean by style sheet?
This is what I see
[image]
/ comments
This is what I see
I'm unclear of what's happening here. I don't get the before/after view here. Is this post formatting? I don't see this behavior, but I wonder if I'm not reproducing this correctly. / comments
I'm unclear of what's happening here. I don't get the before/after view here. Is this post formatting? I don't see this behavior, but I wonder if I'm not reproducing this correctly.
719 is a busy db, but not that crazy. Some of this is the time it takes for comparisons of objects and refreshing. You can lower the refresh rate if you're working in a dedicated model. If you have a shared database, be careful of doing this, or make sure when you check the commit tab, that you examine changes which might be made by others. There could be conflicts or overwrites you want to be aware of. The other suggestion I have is to use SQL Search more to find objects rather than browsing the OE. I tend to browse myself, but that's a poor habit and it can be slow compared to searching for objects. If you have the toolbelt, I'd also use the dependency tracker to get a pick list of items to work on based on a change. So if I change a table, I can get dependent objects to check and order my work with the dependency tracker information. Prompt also has a lot of data about objects, which can reduce the time spent in OE. I know these are workarounds and cumbersome. There is some ongoing work with SQL Source Control, but with the nature of trying to capture changes and update the user, this just isn't a fast process, especially because SSMS doesn't make this easy. / comments
719 is a busy db, but not that crazy. Some of this is the time it takes for comparisons of objects and refreshing. You can lower the refresh rate if you're working in a dedicated model. If you have...
Also, what's the count(*) from sysobjects for your database(s) / comments
Also, what's the count(*) from sysobjects for your database(s)
Does this happen often? Is Counter in multiple tables in this query? Do you know what might be on the right side? / comments
Does this happen often? Is Counter in multiple tables in this query? Do you know what might be on the right side?
In VS, do you have the SQL Prompt menu and suggestions enabled?
[image]
/ comments
In VS, do you have the SQL Prompt menu and suggestions enabled?
Glad to hear it. Hope you don't find any more new issues. / comments
Glad to hear it. Hope you don't find any more new issues.
You can get some versions here: https://www.red-gate.com/products/old-versions
If you want to get a specific one, then let me know and I'll chase it down.
/ comments
You can get some versions here: https://www.red-gate.com/products/old-versions
If you want to get a specific one, then let me know and I'll chase it down.
Is this working for you? Which SSMS version do you have that caused issues with v9? / comments
Is this working for you? Which SSMS version do you have that caused issues with v9?