Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Understanding full text indexing
Message
From
17/12/2010 16:17:46
 
 
To
17/12/2010 14:23:43
General information
Forum:
Microsoft SQL Server
Category:
Full text indexing
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01493016
Message ID:
01493160
Views:
48
>>It looks like SQL 2008 makes use of "stopwords" and "stoplists": http://technet.microsoft.com/en-us/library/ms142551.aspx
>>
>>The issue with "the" is almost certainly associated with that. I don't know about "with" or "when" but per the article you can query your database for your current stopwords/stoplists.
>
>I took a look at the FTData directory, as I read somewhere in regards to that point, and was only able to find about 10 words, and those were not including THE, WITH or WHEN, for example. I also do not want to do a combined query or have to look in a secondary table, such as the stopwords or stoplists as this shouldn't be like that. I am trying to see if a KEEP ALL or something like that could be in effect.
>
>Mr. Korenthal was way ahead of his time when he built PHDBase. Was he has done was simply amazing. We were able to KEEP ALL and do much more settings are index time. I wish Microsoft would have hired him when they made that full text search engine in SQL Server.

For viewing your stopwords, did you try the system stored procedures in the above link, in the section titled "Viewing Stoplists and Stoplist Metadata"?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform