Full Text Search Custom Dictionary

Question

Full Text Search Custom Dictionary

SQL Dude-467553

Hall of Fame

Points: 3895
More actions
September 3, 2010 at 2:58 pm

#225684

Has anyone setup a custom Full Text Search dictionary that has a good article detailing the correct steps to configure this in SQL 2008R2?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

douglas.laudenschlager SSC Enthusiast Points: 175 More actions · Answer 1

I was surprised to see your recent post because I've also been trying to get this to work since yesterday. I hope to have more information soon.

Theoretically the steps are the same as here: http://technet.microsoft.com/en-us/library/cc263242.aspx, except for:

1. Binn folder

2. exec sp_fulltext_service 'restart_all_fdhosts'

...but so far I'm not successful.

-Doug

Jon.Morisi SSChampion Points: 12846 More actions · Answer 2

Does this help?

http://msdn.microsoft.com/en-us/library/ms142491%28v=SQL.100%29.aspx

douglas.laudenschlager SSC Enthusiast Points: 175 More actions · Answer 3

Not the same thing.

Here's more about custom dictionaries in SQL Server FTS:

http://blogs.msdn.com/b/sqlfts/archive/2009/12/03/did-you-know-that-sql-server-2008-provides-the-ability-to-create-a-custom-dictionary-of-special-terms-to-be-indexed-as-is-i-e-at-t-into-the-ftindex.aspx

I'm just having trouble getting the results that I would expect - can't tell yet whether I chose poor examples for my test file, or it's just not working...

Thanks,

-Doug

Jon.Morisi SSChampion Points: 12846 More actions · Answer 4

I recall reading that if you upgrade from 2005 to 2008 and don't rebuild with full population that the 2005 word stemmers are used vs. the 2008 word stemmers.

Did you upgrade? Maybe try to repopulate anyway...

http://technet.microsoft.com/en-us/library/cc721269%28SQL.100%29.aspx#_Toc202506230

douglas.laudenschlager SSC Enthusiast Points: 175 More actions · Answer 5

I'm actually testing on a clean Denali build on a clean machine, with the latest word breakers. I'm also just using sys.dm_fts_parser queries, so no relying on a full-text index.

I got some more suggestions before leaving work on Friday but didn't have time to test them. THANK GOD I didn't post the blog post that I'm writing without testing everything.

I'll post what I learn after I'm done. Unfortunately it's not so simple as "ask a buddy on the Full-Text Search team" since they don't produce the breakers.

-Doug

SQL Dude-467553 Hall of Fame Points: 3895 More actions · Answer 6

I've resolved my issue by following this Microsoft Blog.

http://blogs.msdn.com/b/sqlfts/archive/2009/12/03/did-you-know-that-sql-server-2008-provides-the-ability-to-create-a-custom-dictionary-of-special-terms-to-be-indexed-as-is-i-e-at-t-into-the-ftindex.aspx

One of the root issues is that the word breaker DLL's shipped with 2008 were not the latest version.

Full Text Search Custom Dictionary

Cookies on SQLServerCentral