Comments
Sort by recent activity
Sounds good. Thanks for your quick response. / comments
Sounds good. Thanks for your quick response.
That worked. Thanks for your help. / comments
That worked. Thanks for your help.
I noticed the same problem. Yes, it coincided with the install of SSMS 2016 CTP 2. All my SQL Prompt key shortcuts are gone. Is there an easy way to restore them? / comments
I noticed the same problem. Yes, it coincided with the install of SSMS 2016 CTP 2. All my SQL Prompt key shortcuts are gone. Is there an easy way to restore them?
Restarting SSMS 2012 rebound the keys to their defaults. Which is good...
However, I prefer FormatSQL bound to Ctrl-KD, just like Visual Studio. I also remove the Ctrl-BL and Ctrl-KY bindings to teach my muscle memory to always use Ctrl-KD.
Unfortunately, SQL Prompt appears to wipe out this change, replacing my keys with its defaults. / comments
Restarting SSMS 2012 rebound the keys to their defaults. Which is good...
However, I prefer FormatSQL bound to Ctrl-KD, just like Visual Studio. I also remove the Ctrl-BL and Ctrl-KY bindings to te...
Confirmed that the beta fixes this. / comments
Confirmed that the beta fixes this.
I produced this code using 6.5.0.335.
Looking through my original post, I see that I missed two steps. First, execute just the first two statements. Then refresh your suggestions.
Now you should be able to reformat the UPDATE code shown and see the incorrect result. / comments
I produced this code using 6.5.0.335.
Looking through my original post, I see that I missed two steps. First, execute just the first two statements. Then refresh your suggestions.
Now you should be...
I have been seeing the same behavior.
For me, I've noticed that it takes some time (10 minutes maybe?) for the suggestions to be updated. I run "refresh suggestions" on a large database over a VPN. It might take 30 seconds for the refresh to complete. But the list of suggestions isn't actually updated until later. Immediately running refresh again doesn't help. / comments
I have been seeing the same behavior.
For me, I've noticed that it takes some time (10 minutes maybe?) for the suggestions to be updated. I run "refresh suggestions" on a large database over a VPN....
The "loading database" box is visible and I see it progressing through processing objects, columns, parameters, indexes, script information, etc. Timing it this morning shows about 20 seconds.
I most often notice this when adding new columns to a table which I then want to immediately use as part of a SELECT or INSERT. Although I have seen it happen when creating a new stored procedure, too. However, this is not consistent. I just attempted to recreate the problem on the same server and couldn't.
Yes, I think this is new in the past few months. Sorry, I can't narrow it much further than that.
This is not a trivial database but it's not huge, either. Here are the object counts.
81 CHECK constraints
2480 Default or DEFAULT constraints
439 FOREIGN KEY constraints
3 Inlined table-functions
1934 PRIMARY KEY or UNIQUE constraints
77 Scalar functions
1444 Stored procedures
67 System tables
13 Table functions
23 Triggers
2140 User tables
318 Views / comments
The "loading database" box is visible and I see it progressing through processing objects, columns, parameters, indexes, script information, etc. Timing it this morning shows about 20 seconds.
I mo...
OK, I figured out the problem. I had installed another SQL Prompt-like product. When I installed the other software, the problem went away.
Perhaps, the other product and SQL Prompt were both attempting to do the same thing at the same time. If you'd like to attempt to recreate, PM me for details. / comments
OK, I figured out the problem. I had installed another SQL Prompt-like product. When I installed the other software, the problem went away.
Perhaps, the other product and SQL Prompt were both attem...
It's not that I'm opposed to semicolons in SQL. It's just that I've never written SQL with semicolons, except for when it's been required by a CTE or DDL.
Because I work on a team of developers, we'll all need to agree. Otherwise, we'll end up flipping back and forth.
One more thing. I noticed there is text at the top of SQL Prompt - Options - Format > Actions: "When you run Format SQL (Ctrl+K, Ctrl+Y), SQL Prompt will:". Does this text change if the keystroke is changed? Would that be hard? My keystroke is Ctrl+B, Ctrl+L, I'm not sure why. / comments
It's not that I'm opposed to semicolons in SQL. It's just that I've never written SQL with semicolons, except for when it's been required by a CTE or DDL.
Because I work on a team of developers, we...