SQL Server Full-Text Search Performance
Tue, 9 Oct 2007 09:42:00 -0700
Hello,
We are using SQL Server 2000 and we are doing Full-Text Indexing on a table
that has 5 Text Columns (we have Full Text Indexing on these 5 columns).
There are around 1.5 million records in this table. And the size of the
Full-Text Catalog is around 1 GB.
The performance issue we are facing is som ...
|
Re: Fulltext Contains Problem
Mon, 8 Oct 2007 08:31:10 -0400
r.e.m. is indexed as r e m if r, e, and m are not in your noise word list.
R.E.M. is indexed as R.E.M and REM.
--
RelevantNoise.com - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Servic ...
|
FTS and hyphens
Wed, 14 Mar 2007 16:06:03 -0500
Hello,
Is there any way to work around the behavior of searching for a term
which has hyphens in it? I've seen the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q200043 which
only suggests doing a non-FTS search. Is there no way to transform the
search term so that it will return a ...
|
Phonetic Searching and Full Text Indexing For Business and Personal Names an Addresses
10 Mar 2007 05:36:08 -0800
I am undertaking a project which requires the ability to perform
phonetic searching across business and personal names and addresses.
This data is relatively uncleansed to date. The amount of work to
cleanse the data is tremendous based upon existing data analysis. My
thoughts are that if we can find the rig ...
|
Unicode and Sharepoint Services 2.0
Fri, 9 Mar 2007 07:46:08 -0800
Hi,
Does anyone know whether we can get Unicode search working on Sharepoint
services v2.0.
I know WSS 2.0 uses SQL Server's full-text-search.
Andy Bolton ...
|
FTS Installation Problem - unavailable in SQL Server
Thu, 8 Mar 2007 11:27:01 -0800
Hello, I have a SQL Server 2000 sp4 server. Trying to install Full-Text
Search. I can see the Microsoft Search service and it shows as started. But
the Full-Text Search option in SEM is 'grayed out'. The FTS system procs
also report that FTS is not available. SQL Server has been stopped/restarted
but ...
|
C# in Freetext
Tue, 6 Mar 2007 04:07:53 -0800
Probably been answered before but can't find it anywhere in these threads
We are implementing an application for a recruitment company and need to
search for skills, we are trying to use SQL FullText Search but it refuses to
find C# which is definitely in the database.
We have found the reason why it won ...
|
|
|
CONTAINSTABLE Column Weighting in FTS 2005
Mon, 5 Mar 2007 15:39:56 -0000
Hi there,
Is it possible with SQL Server 2005 to add weighting to a column in a
CONTAINSTABLE or FULLTEXTTABLE ?
I've got the statment :
SELECT ftt.RANK, [content].id, [content].title, [content].content_data FROM
[content] INNER JOIN CONTAINSTABLE([content], (title, content_data),
'Summary') as ftt ...
|
Full-Text Search
03 Mar 2007 10:03:02 GMT
I would like to use the Full-Text Search in MS SQL 2000, but I'm not
sure whether I can use it in my setup.
In my application the user is able to type some text (about 400
words). In the database I have a list of words that I would like to
match to the text. Is it possible to use stemming etc in this
co ...
|
Full Text Indexing Option Disabled
Sat, 3 Mar 2007 00:14:10 -0500
i can again/still/no longer manage full-text indexes on SQL Server.
i'm logged on locally to my server, as an administrator. EM is set to poll
the server.
Has anyone written a gui to manage SQL Server free-text indexing?
...
|
