I have a SQL 2000 full text catalog with Incremental population and Change
Tracking.
There is a replication job on the table , which replicates every 10 minutes.
Sometimes there is a delay from the time the data appears in the table , to
the point it appears in Full text catalog.
Is there a...
more >>
I have come across a problem. I cannot find the answer here, though
I'm surprised nobody else has asked.
The question is: How should one get SQL FTS to index files' content
which have a suffix/extension not among those supplied by default BUT
perfectly searchable by existing filters? I do *n...
more >>
Hi,
I am using an FT index on a column (varchar(4000) with an average
length of 100) in a table that contains about 1 million rows.
My tiny performance test looks like
declare @t datetime
set @t = getdate()
select count(*) from containstable(table_name, expression,
'"searchthis*"')
pri...
more >>