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

130 results found

  1. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. Database Triggers are missing in result set.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. It would be nice to have SQL Search integrated in Object Explorer context menu. It will simplify first step in search.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. When Object Types: Jobs can you add something in Matches on Enabled Job and Scheduled Job ?

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. 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

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. Adjust the overall font size in the UI by percentage like in a browser.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. 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…

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. Search for a Procedure that has NO parameters, and the code-line ends with a semicolon - Search IS BLIND! What a lousy BUG!

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. When using SQL Search to find a column name within objects, it would be extremely helpful to have an additional column that totals the number of instances of that search string within the search results. Clicking on a row in the search results shows the first instance of the string within the object but if it's a stored procedure, function, trigger, table, or query it's helpful to be able to see the total number of instances of that string within the object.

    Also in the object definition window, it would be really nice to be able to click a button…

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Search within results

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. 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.

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. While not frequent, there are times when I start SQL Search and all of the fields are disabled (see attached image). The only resolution is to exit SSMS and restart.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. 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.

    22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1 3 4 5 6 7
  • Don't see your idea?