Comments
Sort by recent activity
I notice a lag of 2-3 seconds after using Ctrl-Shift-D to refresh suggestions.
I would like to enable auto-refresh of the suggestion but this lag makes it quite painful when the SSMS UI freezes for 2-3 seconds. This is a development db with several devs making changes.
Here are the counts of objects in the current database.
74 CHECK constraints
2405 Default or DEFAULT constraints
432 FOREIGN KEY constraints
3 Inlined table-functions
1925 PRIMARY KEY or UNIQUE constraints
69 Scalar functions
1399 Stored procedures
67 System tables
12 Table functions
17 Triggers
2124 User tables
305 Views / comments
I notice a lag of 2-3 seconds after using Ctrl-Shift-D to refresh suggestions.
I would like to enable auto-refresh of the suggestion but this lag makes it quite painful when the SSMS UI freezes for...
Looks like the suggestions for the first field are fine. It's the second field that is wrong. [image] / comments
Looks like the suggestions for the first field are fine. It's the second field that is wrong.
OK, I found another problem. Using the same example,
select b.<cursor> from APP.TableA a join APP.TableB b on a.TableAID = b.TableAID
If a table named exists in the current database, only the columns of that table will be suggested. The columns of the table alias "b" are not shown. / comments
OK, I found another problem. Using the same example,
select b.<cursor> from APP.TableA a join APP.TableB b on a.TableAID = b.TableAID
If a table named exists in the current database, only the colu...
Thanks, David. The suggestion list is populated as expected with the 204 beta. / comments
Thanks, David. The suggestion list is populated as expected with the 204 beta.
In this release, SQL Prompt doesn't scroll the suggestion popup list based on the table alias.
Given the following code, what would you expect the suggestion popup to contain?
select b.<cursor> from APP.TableA a join APP.TableB b on a.TableAID = b.TableAID
I would expect the suggestion list to contain only b.* columns. But it doesn't. Instead, I am shown both a.* and b.* columns. At a minimum, the suggestion list should be scrolled to the first b.* column.
When working with SQL that contains many joins and table alias, this bug means that I need to lift my hands off the keyboard and scroll the list with the mouse. It's not very efficient.
Kevin / comments
In this release, SQL Prompt doesn't scroll the suggestion popup list based on the table alias.
Given the following code, what would you expect the suggestion popup to contain?
select b.<cursor> fro...
Yes, this build appears to fix the problem. Thanks so much! / comments
Yes, this build appears to fix the problem. Thanks so much!
I'm seeing a similar problem with a cross database SELECT. Expanding "SELECT a.*" with tab produces a list of fields that are completely unrelated to any joined tables. Expanding "SELECT *" works as expected. I did "refresh suggestion" to make sure I wasn't use a stale cache.
Object names are modified.... SELECT Ref.[AP21].[AP_DRG],
Ref.[AP21].[AP_DRG Desc],
Ref.[AP21].AP_MSC,
Ref.[AP21].[AP_MDC DESC],
Ref.[AP21].ID
FROM B.[qCalc] a
LEFT JOIN Dev_SafeCopy.B.[qCalc] b
ON a.[ICODE] = b.[ICODE]
AND a.[CPAY] = b.[CPAY]
AND a.[MAJOR] = b.[MAJOR]
/ comments
I'm seeing a similar problem with a cross database SELECT. Expanding "SELECT a.*" with tab produces a list of fields that are completely unrelated to any joined tables. Expanding "SELECT *" works a...
Since the feature request page aren't operable at present....
bump
In addition to "set focus to search string," here are some more shortcuts that would be handy.
Select the current object in the Object Explorer
PageDn and PageUp in the bottom text view
A scroll-bar indicator showing where in the document search results were found would be very useful. I have to scroll to the bottom of the window to make sure that I haven't missed anything. Chrome implements this for Ctrl-F search results.
I know this is a free tool and I do thank you! It is quite useful, I use it every day. / comments
Since the feature request page aren't operable at present....
bump
In addition to "set focus to search string," here are some more shortcuts that would be handy.
Select the current object in the Ob...
Thanks for the update, Adam.
Ctrl-Alt-D triggers an index refresh for me but doesn't move the focus from the results list. The refresh is a problem in that Ctrl-Alt-D is the same keystroke used to switch to SQL Search from another window. Because I find a keyboard to be much faster than switching to the mouse, my workflow ends up looking like this:
1. Editing query, type..type...type. Hmm, where is this view used?
2. Ctrl-Alt-D...
3. grab mouse
4. click on search textbox
5. type search term
6. wait for index refresh to finish. Because all my SQL Servers are remote via a VPN, it takes up to 60 seconds to finish.
Ideally, the keystrokes to activate or switch to SQL Search, index refresh, and set focus to search textbox would be three different keystrokes. Yes, it's more to remember but it leads to a much more efficient workflow for me. / comments
Thanks for the update, Adam.
Ctrl-Alt-D triggers an index refresh for me but doesn't move the focus from the results list. The refresh is a problem in that Ctrl-Alt-D is the same keystroke used to ...
Turns out this was a bug with SQL Compare expecting to find SQL Source Control installed when the db had extended properties indicating it was linked to a source control system. / comments
Turns out this was a bug with SQL Compare expecting to find SQL Source Control installed when the db had extended properties indicating it was linked to a source control system.