Key Word Searches

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Todd Fifield » Key Word Searches

39 posts, Page 1 of 4

1 2 3 4 »»»

Key Word Searches

Rate Topic

Display Mode

Topic Options

Author

Message

tfifield

Posted Sunday, February 27, 2011 9:44 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, April 05, 2013 8:10 PM
Points: 958, Visits: 2,873

Comments posted to this topic are about the item Key Word Searches

Post #1070308

KermitTheRock

Posted Monday, February 28, 2011 12:15 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, January 21, 2013 8:29 PM
Points: 19, Visits: 87

Does this make sense. Why would you not use the built in full text search. Its good enough to power sharepoints document search. its built in from 2005 on and can easily index any text field.

Post #1070345

paul.knibbs

Posted Monday, February 28, 2011 1:37 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:43 AM
Points: 1,257, Visits: 4,255

I agree with Kermit--does this technique offer any benefits over just using full-text search? You can even get SQL Express with full-text search capabilities now!

Post #1070362

Koen Verbeeck

Posted Monday, February 28, 2011 1:38 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

KermitTheRock (2/28/2011)

Does this make sense. Why would you not use the built in full text search. Its good enough to power sharepoints document search. its built in from 2005 on and can easily index any text field.

My thoughts exactly, why re-invent the wheel if full text search is readily available?

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1070363

roman.pokrovskij

Posted Monday, February 28, 2011 3:04 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, March 16, 2013 12:46 PM
Points: 14, Visits: 41

All this have sense if your are going to search in non English text, or in the text with mixed language's words, and whant to support your own search rules: for example if you need to support synonyms: Baltic, Boltic, Boltik, Baltijske..

Post #1070391

AndrewJacksonZA

Posted Monday, February 28, 2011 3:32 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 5:52 AM
Points: 165, Visits: 1,022

Hi

Please include a link to where Jeff Moden posted his function.

This search turned up this result.

Is that where you got the function from?

Thanks
Andrew

Post #1070395

Jeff Moden

Posted Monday, February 28, 2011 6:18 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:51 PM
Points: 32,906, Visits: 26,789

AndrewJacksonZA (2/28/2011)

Hi

Please include a link to where Jeff Moden posted his function.

This search turned up this result.

Is that where you got the function from?

Thanks
Andrew

That's likely it. I've only posted it a couple of times so far. As I said in the post, I'm still doing some testing on it for a couple of things including a performance curve in different environments.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1070461

Jeff Moden

Posted Monday, February 28, 2011 6:34 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:51 PM
Points: 32,906, Visits: 26,789

I was going to post that the result table and the related methods for this code article are nearly identical to what full-text-search (FTS) does but I see that folks beat me to it. Smile

I've not worked with FTS before so I don't know if this article brings anything extra to the table (yet) and I haven't tested the code in this article (yet) BUT... the article appears to be a reasonable study of how FTS may work behind the scenes to build the "index table" and how it uses special tables for "noise words", etc.

Why is that good? Heh... because SQL Server isn't the only database in town. BigGrin

This article shows how it could be done either in other database engines which may not have an FTS capability or in a "custom database".

--Jeff Moden

Post #1070468

AndrewJacksonZA

Posted Monday, February 28, 2011 7:28 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 5:52 AM
Points: 165, Visits: 1,022

Or in a lower, cheaper edition.

Post #1070513

sqlnoobie

Posted Monday, February 28, 2011 7:47 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, September 26, 2012 8:25 AM
Points: 11, Visits: 50

I've been using FTS on a view composed of several tables, and this method works pretty well, as I can return ranked results using "contains table". Not sure if the method above allows for ranked results?

Also, you don't mention what happens if someone searches for "Hex Nuts" as opposed to "Hex Nut"...how do you account for that? I've resorted to stemming the search terms when the last characters are "s", "es", etc.

Does anyone have any links for "predictive" search solutions in MSSQL, to catch misspellings, etc?

Post #1070529

« Prev Topic | Next Topic »

39 posts, Page 1 of 4

1 2 3 4 »»»

Permissions