Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Understanding full text indexing
Message
De
17/12/2010 14:23:43
 
 
À
17/12/2010 03:08:53
Al Doman (En ligne)
M3 Enterprises Inc.
North Vancouver, Colombie Britannique, Canada
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Indexation intégral de texte
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01493016
Message ID:
01493140
Vues:
51
>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.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform