Sample Full-Text Search Engine

Rating:

(0)

David Jones

SQL Server Magazine

InstantDoc ID #8967

Suppose you want a table to hold all content for your dynamically populated Web site. In the following example, I'll create a simple SQL Server table and a full-text search engine to run against it. Following is the content table:

Create table content (

Pagename		varchar(20) not null primary key,
URL			archar(30) not null,
Description		text null,
Keywords		varchar(4000) null)

In...

You must be a paid Professional Member to access this entire article.

Already a Professional Member? Please log in now:

Monthly or Annual

Professional Membership

VIP Membership

Compare Member Benefits

Add a Comment

And I subscribed just to read the rest of this????

My mistake!

I read the first couple of paragraphs as a visitor and thought it might actually go somewhere so I subscribed ... turns out it's a very basic rehash of info that's readily available in a dozen other places.

If this is what's on offer ... UNSUBSCRIBE ME

Matthew3/17/2007 4:41:17 AM

In order to search and highlight you'll need to do what I did, and build your own routine to generate inflectional forms and word variants to pass to Microsoft Search - you'd be surprised how easy it is to produce better results than the native search engine using 3 relatively simple algorithms including Soundex, Levenstine and Porter's Stemmer.

Anonymous User 6/23/2005 8:34:28 AM

This is one of the greatest articles for learning about something, that I have read. Its clear and easy to understand, wish more tutorials were like this one.
Keep it up!

Anonymous User 2/28/2005 3:18:46 PM

I want to highlight all occurrences of the search within a document - is there a way to read through the text and highlight each occurrence of the search string?

Anonymous User 1/11/2005 11:04:03 AM

In the article does not mention that SQL Server Fulltext could be not "great, "greatest" and greater".
The article need to considerate there are another implication before to create a fulltext index search as well as the process to update, delete, insert and make changes to the database “table or tables”.
The use of FREETEXT, my personal experiences such as "search engine" are difficult. SQL Server take to long to update the data such as added, deleted or updating. In addition, if you have clients that they are depending to update their own data every day, you may have to considerer to find another options.
By Victor Unda
Undaconsulting.com

Victor Unda 3/5/2004 4:49:55 PM

Good and Excellent article. Special Thanks for Mr. David Jones for providing this wonderfull article.

Kannadasan 2/19/2004 11:03:59 PM

Great Stuff, Exactly what I was looking for. Thanks a lot!

Ramiro A. C. Souto 2/19/2004 8:18:10 AM

Hi,

The article is fabulous. I have tried a similar approach but I am getting the following error:
Server: Msg 7607, Level 17, State 1, Line 1
Search on full-text catalog 'Cat_Helpdesk_Bombay' for database ID 14, table ID
357576312 with search condition '"partner"' failed with unknown result

Would you please help me..

Regards,
Fazal
(341ff930).

Fazalhusein Z Patvi 10/25/2001 7:37:22 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

The Essential Guide to Mission-Critical Microsoft SQL Server
A Essential Guide by EMC

SSIS Performance Tuning, Connecting to Heterogeneous Sources, and Complex Transformations
A White Paper by expressor software

Tuna Helper - Tuning SQL Statements: A Proven Process for SQL Server Environments
A White Paper by Confio

The Essential Guide to SQL Server 2008 R2 for the DBA
A Essential Guide by Microsoft

Windows Event 333->

We have a VM that has 8GB memory and is running Windows 2003 Enterprise Server 32bit and SQL Server 2000 SP4.Making no changes the system runs fine an...222-96226