Scripting Full Text Index

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Spondishy - 16 Oct 2006 16:01 GMT

Hi,

I'm using SQL Server 2005 and was just wondering if its possible to get
the values set for full text indexing via
I was just wondering if it is possible to script the full text indexes
setup from the Management Studio (in a similar way as you can for db
tables and sp's).

Also, I've noticed that if a fulltext query isn't fired often, it takes
ages for the subsequent first query to be fired. I'm guessing this is
my settings on the full text query. Should I be tweaking some settings
to make the searches more optimized?

Thanks in advance.

Reply to this Message

Hilary Cotter - 16 Oct 2006 20:16 GMT

I am not sure if the initial slowness is due to incorrect configuration but
it is likely due to the fact that you must retrieve the full-text catalog
pages off disk.

Also what is your max memory set to? You should leave at least 512 Mgs free
for MSSearch/MSFTESQL.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
>
[quoted text clipped - 10 lines]
>
> Thanks in advance.

Reply to this Message

Hilary Cotter - 16 Oct 2006 21:05 GMT

to script fulltext indexes you need to script the underlying tables and
include the scripting of the full-text indexes.

Signature

>I am not sure if the initial slowness is due to incorrect configuration but
>it is likely due to the fact that you must retrieve the full-text catalog
[quoted text clipped - 17 lines]
>>
>> Thanks in advance.

Reply to this Message