674 results found
-
Ability to run Code Analysis against whole DB
With the deprecation of SQL Code Guard and it's replacement by Code Analysis there is one feature that we heavily used that is now no longer there, and that is the ability to run SQL Code Guard against the whole DB not just the query on the screen.
This allowed us to investigate new DBs that we'd inherited to see what sort of cleanup we might be looking at as well as giving us the ability to see if anything had snuck in to our existing DBs without going file by file.
I know there are other tools (like SQL…
16 votes -
Allow tab history to stay open
I want to be able to keep my tab history open. I am rebuilding a lost development database and using search a LOT, but after I search, find a tab I want to look at more deeply or execute, the window disappears and my search predicate and place in the list of matching tabs is lost, so I have to enter search predicate and scroll back down each time. This is a VERY useful tool, but it would be so much more useful if I could just keep it open.
16 votes -
Use icon to denote fields with indexes
When the drop down appears with field names (like when you're typing in a WHERE clause), include a little icon for each field that's the first field in an index (like the key pic when it's the PK).
Being able to say "oh, that one has an index" would help me when trying to figure out how I want to filter things. (aka use "insertedtime" vs "posttime" vs the "start_time"). I'd say to use one icon (maybe greyed out) for non-clustered, and a different (or not greyed-out) icon for the clustered. You already include the field size, so…
16 votes -
16 votes
-
Convert code to dynamic Code
Convert selected CODE or a complete stored procedure to Dynamic SQL Code.
16 votes -
Organize objects in SSMS with a folder stucture
The reason I would like to see the folders is strictly for organizational purposes. I have so many procedures and tables in one database that I have to scroll through them all to find what I’m looking for. If I could organize by schema (or however I choose) and very quickly and jump back and forth between the different folders, that would help me out tremendously. The SQL filter function is so slow when going back and forth.
What if I could organize sql instances that I'm connected to in one SSMS. Production and Development folders?? Just another thought.
16 votes -
Better memory management
Sql Prompt is a memory hog and causes SSMS to routinely be my biggest consumer of available memory. I just opened SSMS and refreshed the objects in a rather large database and SSMS is consuming 572 MB of memory. When you compare this to the 92 MB that SSMS uses on a fresh start up the difference is quite shocking.
16 votes -
SQL history - Reintroduce lost features
SQL history. Recently this has become more indepth with greater search and history detail available. However it has lost some features which I found to be invaluable and which now make SQL history less useful to me.
Find Starred items doesn't work as well now. It uses the advanced search which does not actually show if items are starred. Please correct that.
Also there is now no ability to sort items found (in either normal or search view) by name / date etc.
Can these features be re-implemented please.
15 votes -
Automatically alias tables and columns in existing scripts
Please could you add a feature that parses a query that has already been written, adds aliases for tables that don't already have them and update columns to use those aliases.
This is because I often get pieces of code which are partially aliased and I have to go through updating the missing ones. Thanks.
15 votes -
Allow item following AND/OR to be on new line
When formatting SQL, it would be good to have the option to put the item following an AND/OR on a new line and align it, so instead of:
WHERE
OutgoingResults.LoadDateKey = 20191106
AND OutgoingResults.FeedName = 'TestFeed'we have
WHERE
OutgoingResults.LoadDateKey = 20191106
AND
OutgoingResults.FeedName = 'TestFeed'14 votes -
Mark same columns in JOIN conditions
It helps avoiding join on the same column (especially at inner join).
Example:
UPDATE A SET Column1 = B.Column2 FROM TableA AS A INNER JOIN Table B ON A.Column3 = A.Column3.
It happens usually by accident. The statement should be:
UPDATE A SET Column1 = B.Column2 FROM TableA AS A INNER JOIN Table B ON A.Column3 = B.Column3.14 votes -
Format CTE closing parenthesis
It would be nice to have an option under Formatting Style -> CTE to allow closing parenthesis behavior, just like the opening parenthesis one:
- Place closing parenthesis on new line
- Closing parenthesis alignment14 votes -
Align "then"
Please add an option to align "then" keyword and the expressions.
Current format:
declare@fooidint=(case
_______________________when@barId=7then2
_____________________when@barId=800then1
_____________________else5
_________________end
__________________);Suggested format:
declare@fooidint=(case
_______________________when@barId=7then2
____________________when@barId=800_then1
_____________________else________________5
________________end
__________________);14 votes -
Add the command "USE [DatabaseName]" at the top of the script, when using the 'Script Object as Alter F12' feature.
Hi,
I really love the feature to just press F12 on SP and SQLPrompt opens a new query window with an alter script. It improves the productivity and it's a way easier then scrolling or filtering in the object explorer or using the tool tip by copy & paste the definition.Do you know if there is any possibility to add the command "USE [DatabaseName]" at the top of the script. So, in case I need to switch my connection to a different server I don't need to select my database from the available database list drop down in SSMS.
14 votes -
Choose to have ALTER instead of CREATE scripts
When I hover over an object and get the pop-up script for that object (proc/view/function) I would like the ability to have the script default to ALTER instead of CREATE.
99.9% of the time I manually have to edit the Create to be an Alter, this would save SO MUCH time.
14 votes -
Please include support for Extended Events in SQL Prompt
Extended Events is a great feature in SQL Server. Without support for this in SQL Prompt makes it incomplete.
I know we have a GUI for it in SQL Server 2012. But it will quite sometime before everybody is on the latest version of SQL Server14 votes -
Make SQL Prompt & SCG Command line ignore code where scgignore is set
We have adopted SCG and have commented out areas of code we do not want checking with scgignore. The new version of SCG command prompt and SQL Prompt do not recognise these comments, and report the area of code with warnings.
Please amend so they are not reported, or at least reported differently so we can ignore.13 votes -
Indent statement after IF when not enclosed by BEGIN/END block
if blah=1
____return 1;if blah=2
_begin
_return 2;
_end
else
_return 0;13 votes -
export to excel options
Hi - export to excel is a great feature. if it could be extended in 2 ways it would be even better.
copy the sql used to produce the results (and date, server info) into a separate tab called 'sql' or something. this way data extracts will be 'auditable' and re-runnable.
have some export options (top row = bold, highlighted, freeze top row). column autowidths applied.
the second one can be done with a macro in the excel template but would be a nice to have.
13 votes -
when aggregating add alias
when doing simple aggregation such as sum(column), it would be nice if the column name would be aliased after the agg automatically. if this is a single column in the function then make the alias the column name. when multiple then create square brackets and move cursor into bracket after closing agg with a ")"
13 votes
- Don't see your idea?