Skip to content

SQL Search

Welcome to the SQL Search feature suggestion list. Find out more information about SQL Search at http://www.red-gate.com/products/sql-development/sql-search/

SQL Search

Categories

JUMP TO ANOTHER FORUM

(thinking…)

How can we improve SQL Search?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

134 results found

  1. Tab through all instances found in proc displayed in preview or show count of how many instances found in proc that's being previewed.

    After the results have been displayed, it would be nice to click a key (ex. F5) to jump to each instance of the result found in the procedure displayed in the preview window.

    Or have a count indicator of how many instances were found in the procedure that's being viewed in the preview.

    3 votes
    0 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

  2. Add a script to Alter for Stored procedures found in SQL Search.

    Add a option when you right click on the stored procedure you found to script it to an alter page similar to how you can do that if you find a nested SP in your code.

    6 votes
    1 comment  ·  Data search  ·  Admin →
    How important is this to you?

  3. Search Stored Procedure by name shows the SQL Jobs and Steps that procedure is called from

    When you search for a stored procedure, it shows its name and details.

    It would be helpful to know which SQL Server Jobs and steps call/execute that stored procedure. That allows me to understand the importance and extent to which that stored procedure is used.

    4 votes
    0 comments  ·  Schema search  ·  Admin →
    How important is this to you?

  4. Would be nice if the database (and other) filter(s) would persist their value across restarts.

    I work on a server with hundreds of databases, but only deal with one. It would be nice if I could persistently filter to just the one.

    1 vote
    0 comments  ·  Admin →
    How important is this to you?

  5. Indexing Control

    It's linked to other questions/requests, but slightly different. I would personally rather that indexing results were persisted between sessions and then updated in the background. As things stand, I have to wait around 3 minutes every time I want to search for something, which disrupts the workflow. I would much rather put up with cached results that were displayed immediately, whilst being refined in the background.

    You could also use some more advanced operators (eg '-' for exclusions etc)

    1 vote
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

  6. Provide column options. For example, searching tables for a specific field like zip code - data type shows where joins could be an issue

    Provide column options. For example, searching tables for a specific field like zip code - data type would show where joins could be an issue if some are Float and others are Varchar

    1 vote
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

  7. Database Triggers

    Database Triggers are missing in result set.

    2 votes
    0 comments  ·  Admin →
    How important is this to you?

  8. Use SSMS fonts and keyword colors in Object Preview

    One thing I like about ApexSQL Search is that it uses my configured font styles and keyword colors from SSMS in the object preview/definition window. I would LOVE to see this implemented in the RedGate tool because it would make it easier to read the object code.

    3 votes
    0 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

  9. CREATE TABLE definition for tables in preview pane

    As with other objects, I would like to see the CREATE TABLE definition in the preview pane when a table is selected in the search results.

    This would give the same information to the user that the current table preview gives, with the added bonus of being able to copy and paste the results if we want to re-create the same table (say, under a different database or schema, or just with a different name), just as we can for views, SPs etc.

    3 votes
    0 comments  ·  Admin →
    How important is this to you?

  10. SSMS Integration

    It would be nice to have SQL Search integrated in Object Explorer context menu. It will simplify first step in search.

    1 vote
    0 comments  ·  Admin →
    How important is this to you?

  11. enabled

    When Object Types: Jobs can you add something in Matches on Enabled Job and Scheduled Job ?

    1 vote
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

  12. Font Size setting for SQL Search results

    Simply allow font size settings on SQL Search results ... OR ... Post where in Windows this default font might be found. Current results are so small as to be very difficult to use

    5 votes
    0 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

  13. Adjust the overall font size in the UI by percentage like in a browser.

    Adjust the overall font size in the UI by percentage like in a browser.

    1 vote
    0 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

  14. Search option 'match whole words only' does not work as expected with database objects.

    Allow me to explain by examples.

    Example A:
    I enter the search term 'test' (without the apostrophes) and I DO NOT check the 'match whole words only' option. I get the following hits:
    - somethinginfronttest
    - testsomethingbehind
    - test
    - [test]
    - dbo.test
    - dbo.[test]
    So far so good, all hits are as expected.

    Example B:
    I then enter the search term 'test' (without the apostrophes) and I CHECK the 'match whole words only' option. I get the following hits:
    - test

    And that's it. I do not get the following hits:
    - somethinginfronttest
    - testsomethingbehind
    - [test]
    - dbo.test…

    4 votes
    1 comment  ·  Data search  ·  Admin →
    How important is this to you?

  15. Start search at button press

    Search start - please make it at button press. The current "automatic" start might be annoying, especially when a very long search starts automatically after the input fileds are touched/leaved.

    18 votes
    3 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

  16. SSMS Schema Folders compatibility

    This add-on moves schemas to a folder (e.g. Database -> Tables -> Schemas -> list of individual tables). Both add-ons dramatically increase's SSMS' usability. Search for obvious reasons. Schema Folders for easy keyboard jump to objects (e.g. typing tab to jump to "TableName" instead of dbo.tab). But the 2 don't work together. "Select object in Object Explorer" no longer works once I have Schema Folders installed. It often ends up somewhere in the sys folder, without actually jumping to the object.

    Having both work would be gravy for my data warehouse (100s of tables/procs) means lots of scrolling otherwise.

    Add-on…

    15 votes
    1 comment  ·  Admin →
    How important is this to you?

  17. Search within results

    Search within results

    5 votes
    1 comment  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

  18. Case Sensitive Searches

    Would like to be able to enable case-sensitive searching. JSON field names in SQL are case sensitive.

    example: JSON_VALUE(MyJsonColumn, '$.caseSensitiveFieldName')

    Sometimes not everyone on the team is on the same page during development, and half the team uses "CaseSensitiveFieldName" and the other half uses "caseSensitiveFieldName". Eventually we realize the disconnect and have to go back and standardize things. So a case sensitive search would really help.

    1 vote
    0 comments  ·  Admin →
    How important is this to you?

  19. Save Search Results

    Please provide an option to save the search results to a file. This is very helpful when there are a lot of objects that match the search criteria.

    17 votes
    0 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

  20. Add a way to stop automatically searching when I open SQL Search

    It remembers the last search term, but not which databases I limited to the last time I searched. So everytime I open it, it tries to search multiple databases that I don't have permissions to. At least once a week I get asked by the DBA's what on earth I am doing.

    23 votes
    0 comments  ·  Schema search  ·  Admin →
    How important is this to you?
← Previous 1 3 4 5 6 7
  • Don't see your idea?