hi, i've noticed that in our SQL 2000 systems fulltext search performance
suffers when one searches for a term that occurs frequently in the index.
(of course i realize that ultimately there is no way around this, but I have
some ideas i'd like to explore.)

Hi, we're having a problem with a full-text index not picking up new
rows that have been added since a recent DB server upgrade.
We migrated our database from SQL Server 2000 to 2005 last week (and
to a new machine as well).  I copied over the tables, recreated the

I believe that SQL 2000 full text is accent sensitive by default for full
text indexing. Can anyone confirm this?
Also. is there any work-around?
What I want to do is seach for "cancer" and return everything that has

I have been trying to figure out how to do a search against my full-text
index where a user enters more than one word.
I can get results back if I just do a search for the name Bob but I can't
figure out how to get reuslts back if I enter Bob Smith.

We are using FTS on a table which has for the moment 4500 rows.
When we restart the FTS-service, or no one uses the search for a while, then
the first FTS-query takes up to 60 seconds. (also when there is only 1 record
returned)

I am looking for an alternative to the SQL Server Fulltext Engine
since it is just not fast enough and does not offer the sorting I
require. Also, my customer wants a "did you mean google" when "gogle"
was entered feature. From what I have seen all that is possible with

We need to index and search on "(specific text here)".
How can we do a free text search using the above.

Howdy folks,
Some of you may have experience the issue described in the following
MS kb article, "You may experience a 45-second delay when you run a
full-text query in an instance of SQL Server 2005 that is running on a

I’ve been searching for information on how Full text indexing uses hardware
resources (Memory, IO, CPU etc) and how I can plan for scaling up data
volumes and search numbers. I have found that there is more information
regarding improving the actual indexing process but this is a ...

Hi All Full-text search experts,
I have an SQL Server 200 Database running with full-text search
enabled and fully operationnal.
I am looking to get the Full-text catalog content to know what are the

I would like to search the words like O'Donnel, O'Connor,Steve's etc.. in the attachments. Tried to use ContainsTable and replaced the apostrophe with another before sending to the search engine.
Also i have to search Connor in O'connor
Any thoughts
From http://www.developmentnow ...

I had a query on sql database, we know we usually store files of
different type in sql database and its helpful for searching and
retrieving the documents from the database, but one query i had was
related to the amount of space required to store the files in the

I am getting the above error message from MOM 2005.
Microsoft Cluster Service 'SQL Server Group' - 'SQL Server Fulltext' State.
Cluster Service health check.
Can anyone help with a solution?

Is there a way to get the Index keywords list?
here is what i need to do
Our database contains a relative small amount of documents so we need
an application that shows ListBox of keywords sorted by index

I don't know if this is an appropriate problem for this forum but will
pose it and if anyone can help, I would be very grateful.
I can run this weighted values FTS in Management Studio on a SQL
Server 2005 db: