Full-text Indexing for a view with multiple databases
Can MS SQL support full-text indexing for a view that connects (joins or unions) multiple databases? ...
full-text-search
How could I generate a contextual text extract from text returned from a SQL Server Full-Text Index?
I'm experimenting with an idea using SQL Server's Full Text Indexing. It seems perfect for the task, but what my client wants is a very Google-like results summary, where the results display an extract of the text around their search term. If I search for "house"... My House Is a Very, Very, Very Fine House ...thanks for coming t...
Hit Highlighting with SQl Servr 2008 FTS
This question was here already but there was no answer, so trying one more time - how to do hit highlighting of results with SQL 2008 FTS? So far I found SQLHighlighter but it is commercial product. I also tried solution described in this book http://apress.com/book/view/9781430215943 but performance was extremely poor. As last resort I...
Recognize Missing Space
How can I recognize when a user has missed a space when entering a search term? For example, if the user enters "usbcable", I want to search for "usb cable". I'm doing a REGEX search in MySQL to match full words. I have a table with every term used in a search, so I know that "usb" and "cable" are valid terms. Is there a way to constru...
Mysql full text indexing limitations?
What are the limitations or gotchas or antipatterns or pitfalls? It seems pretty attractive, apparently you can create a search engine with almost no work. But it cannot be without its problems... what are your experiences? ...
Whats the best way to retrieve information from Sphinx (in PHP)?
I'm new to sphinx, and I'm seting it up on a new website. It's working fine, and when i search with the search in the console, everything work. Using the PHP api and the searched, gives me the same results as well. But it gives me only ids and weights for the rows found. Is there some way to bring some text fields togheter with the 'mat...
Using Perl, how do I show the context around a search term in the search results?
I am writing a Perl script that is searching for a term in large portions of text. What I would like to display back to the user is a small subset of the text around the search term, so the user can have context of where this search term is used. Google search results are a good example of what I am trying to accomplish, where the cont...
Why am I getting this error on my local database and not on my live database?
when I am querying the local database instead of live database I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Shop' because it is not full-text indexed. Why is this happening? ...
SQL Server 2005 Full Text forum Search
I'm working on a search stored procedure for our existing forums. I've written the following code which uses standard SQL full text indexes, however I'm sure there is a better way of doing it and would like a point in the right direction. To give some info on how it needs to work, The page has 1 search text box which when clicked will ...
What's The Best Approach To Do Keyword Searching On A Text Field?
I have a database table which holds meta data about images, the field in concern is the caption field. I want users to be able to enter keywords into a textbox and have the app return a selection of images that match the keywords based on their caption. I already have the code that returns an array of the individual keywords entered by ...
search HTML stored as binary image in SQl2000/2005 (without fulltext)
I am building a simple search tool to search through 'n' articles of html content. I have tried the fulltext search option and all was well until we went live and I have had a load of trouble with the webhost getting stuff sorted properly. So I might have to move to a host that does not have SQL fulltext support. All of the articles ar...
Why does calling full text search in SQL Server 2008 fail when inside transaction scope?
The following code: var foo = Users.Join( tvf_SearchUsers(queryString), u => u.User_Id, s => s.User_Id, (u, s) => u); Selects users that match the query string based on a table valued function (tvf_SearchUsers), which utilises full text search. This code snippet is part o...
SQL Server FTS Timeout Error in ASP.Net, after application is idle for some time
Hi, We have a page calling a Search stored procedure which internally uses SQL Server 2005 FTS. If the application remains idle for 10-15 mins, the first consequent call to the stored procedure times out. All subsequent calls work. Is there any way to prevent this from happening? We don't want the first user getting a timeout and we al...
Replacements for Full Text Search
I am not a big fan of Full Text search with MSSQL(not sure if there is another) does anyone know of any other options to this? ...
Search for "whole word match" in SQL
I would like to write an SQL query that searches for a keyword in a text field, but only if it is a "whole word match" (e.g. when I search for "rid", it should not match "arid", but it should match "a rid". I am using MySQL. Fortunately, performance is not critical in this application, and the database size and string size are both com...
What's the best document search engine to integrate into Perl code?
What is the best document search engine (perhaps Plucene?) to integrate into Perl code that allows customizing and tuning the search algorithm? ...
Get term frequencies in Lucene
Is there a fast and easy way of getting term frequencies from a Lucene index, without doing it through the TermVectorFrequencies class, since that takes an awful lot of time for large collections? What I mean is, is there something like TermEnum which has not just the document frequency but term frequency as well? UPDATE: Using TermDoc...
MySQL FULLTEXT Search Across >1 Table
As a more general case of this question because I think it may be of interest to more people...What's the best way to perform a fulltext search on two tables? Assume there are three tables, one for programs (with submitter_id) and one each for tags and descriptions with object_id: foreign keys referring to records in programs. We want th...
Apostrophes and SQL Server FT search
I have setup FT search in SQL Server 2005 but I cant seem to find a way to match "Lias" keyword to a record with "Lia's". What I basically want is to allow people to search without the apostrophe. I have been on and off this problem for quite some time now so any help will really be a blessing. ...
Hash Join Showing up on Full Text Query - SQL Server 2005
I have the following Query in SQL Server 2005: SELECT PRODUCT_ID FROM PRODUCTS P WHERE SUPPLIER_ORGANIZATION_ID = 13225 AND ACTIVE_FLAG = 'Y' AND CONTAINS(*, 'FORMSOF(Inflectional, "%clip%") ') What's interesting is that using this generates a Hash Match whereas if I use a different SUPPLIER_ORGANIZATION_ID (older supplie...