Red Gate forums :: View topic - Search Capability Limited to 150 Maximum Results
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Search 1
SQL Search 1 forum

Search Capability Limited to 150 Maximum Results

Search in SQL Search 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
marias



Joined: 05 Jul 2011
Posts: 2

PostPosted: Tue Jul 05, 2011 10:13 pm    Post subject: Search Capability Limited to 150 Maximum Results Reply with quote

The search capability limits my results to 150 maximum matches in cases where the search criteria should return more than 150 results (ie. searching for dbo). Is there any settings that can be updated to get around this limitation? Your help would be grealty appreciated! Very Happy

I'm running SQL Server 2008 R2
Microsoft SQL Server Management Studio 10.50.1600.1
Redgate SQL Search ver. 1.0.0.321
Back to top
View user's profile Send private message
aolcot



Joined: 28 Jun 2011
Posts: 25

PostPosted: Wed Jul 06, 2011 8:46 am    Post subject: Reply with quote

I don't think it is configurable. You break the searches down by type i.e. filter by tables, then by views etc. What are you trying to achieve as there may be another way to achieve what you need to do?
Back to top
View user's profile Send private message
marias



Joined: 05 Jul 2011
Posts: 2

PostPosted: Wed Jul 06, 2011 10:15 am    Post subject: Reply with quote

I would like to know all of the occurrences that the search text appears in, but I'm not able to determine this since it's always limiting itself to 150 results max. I tried breaking the searches down by type, but it still limits itself to 150 results.
Back to top
View user's profile Send private message
aolcot



Joined: 28 Jun 2011
Posts: 25

PostPosted: Wed Jul 06, 2011 10:29 am    Post subject: Reply with quote

Ok, as a workaround and unless anyone can update this thread with a way to configure SQL Search, I would probably look to querying the information schema views if you are unable to refine the search any further. For example:

To find any routines that contain the search term in the name of the routine or definition of the routine you could perform a query similar to:

SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_NAME LIKE '%something%' OR ROUTINE_DEFINITION LIKE '%something%'

And to find columns containing a term in the column name:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%something%'

and again for tables containing a term in the name:

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%something%'

There are a number of other information schema views that you can query to search for terms in views, parameters, constraints etc.

I know that it doesn't highlight exactly where the search term is like SQL Search, this may help you achieve in part with what you need to do by compiling a list of objects that contain the search term that you are interested in investigating further.
Back to top
View user's profile Send private message
unclebiguns



Joined: 13 Apr 2010
Posts: 11

PostPosted: Thu Sep 08, 2011 7:50 pm    Post subject: Reply with quote

I just ran up against this limit as well and was going to start a thread about it.

I'd love to see this be configurable as I have a database with over 1000 sp's and I'm trying to identify a call to another database within the sp's and I hit the 150 limit.
_________________
Jack Corbett
http://wiseman-wiseguy.blogspot.com
SQL Server DBA
MCITP: Database Administration SQL Server 2008
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Fri Sep 09, 2011 2:29 pm    Post subject: Reply with quote

What would you say a sensible limit was? We'd rather avoid adding options if at all possible.

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
unclebiguns



Joined: 13 Apr 2010
Posts: 11

PostPosted: Fri Sep 09, 2011 2:44 pm    Post subject: Re: Reply with quote

David Atkinson wrote:
What would you say a sensible limit was? We'd rather avoid adding options if at all possible.

David Atkinson
Red Gate Software


Actually 150 is probably a good choice for display. Could paging be implemented? Even a a message saying 150 of N displayed would be better because there is nothing in the application that tells you that there are more than what is being displayed.

In my case I was searching for references to a second database because there are those who want to move those functions into the current database. Most procedures and functions have references to this database so I wanted to get a number and generate a list. I can do it using T-SQL, but SQL Search could have been perfect, if it returned all the rows (at least a count) and if I had a way to export to csv or excel. So I'd suggest keeping the display limit to 150 and adding a total found count and a way to export all results.
_________________
Jack Corbett
http://wiseman-wiseguy.blogspot.com
SQL Server DBA
MCITP: Database Administration SQL Server 2008
Back to top
View user's profile Send private message
erwino



Joined: 08 Feb 2010
Posts: 2

PostPosted: Fri Sep 09, 2011 2:58 pm    Post subject: Search Capability Limited to 150 Maximum Results Reply with quote

Is it possible to limit to 150 with the option to show all when there are more available? This would allow a quick search up to 150, indicating that there are more or you should narrow your search. If the search is correct you can then opt for all results.
_________________
semper in excretia sumus solum profundum variat
Back to top
View user's profile Send private message
meklembl



Joined: 24 Aug 2007
Posts: 89
Location: Solon, OH, USA

PostPosted: Thu Oct 20, 2011 2:56 pm    Post subject: A vote for a combination of the two Reply with quote

I do like the option of getting all the results after display the first 150 of N results found.
_________________
Larry M
Cleveland, OH USA
Back to top
View user's profile Send private message
pyousefi



Joined: 06 Mar 2012
Posts: 5
Location: McLean, United States

PostPosted: Tue Mar 06, 2012 6:11 pm    Post subject: So where does this stand? Reply with quote

So will pagination of all results be implemented? If so, when will this be offered?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Tue May 08, 2012 9:58 am    Post subject: Reply with quote

Please submit your requests for changes to SQL Search to its' Uservoice site - it's far better than using the forums for this sort of thing. http://redgate.uservoice.com/forums/101149-sql-search-feature-suggestions
Back to top
View user's profile Send private message
yar229



Joined: 25 Apr 2012
Posts: 2

PostPosted: Wed May 16, 2012 2:48 pm    Post subject: Reply with quote

Workaround: there is System.Data.SQLite.dll in "c:\ProgramData\Red Gate\SQL Search\Source" and "c:\ProgramData\Red Gate\SQL Search\Active".
This dll is opensource, so u can download sources and modify SQLiteCommand replacing in CommandText " limit 150" to " limit 500" Smile
Back to top
View user's profile Send private message
yar229



Joined: 25 Apr 2012
Posts: 2

PostPosted: Wed May 16, 2012 6:31 pm    Post subject: Reply with quote

Well, here it is patched for max 400 results.
Unpack files to "x:\ProgramData\Red Gate\SQL Search\Active" and "x:\ProgramData\Red Gate\SQL Search\Source" overwriting existing System.Data.SQLite.dll

SQLSearch_SQLite_patched_for_limit_400.zip
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group