SQL 2005 - Full Text Index question

SQL 2005 - Full Text Index question

Post by Piero 'Gio » Fri, 24 Aug 2007 07:12:14


Hi!

I'm using the Thesaurus search on a SQL Server 2005 Db

The thesaurus file is built like this (Reduced version)

<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics = false/>
<expansion>
<sub>William</sub>
<sub>Billy</sub>
</expansion>
<expansion>
<sub>Maria</sub>
<sub>Mary</sub>
</expansion>
<expansion>
<sub>Paul</sub>
<sub>Pablo</sub>
</expansion>
<expansion>
<sub>Richard</sub>
<sub>Ricky</sub>
</expansion>
<expansion>
<sub>Rebecca</sub>
<sub>Reba</sub>
<sub>Becky</sub>
</expansion>
</thesaurus>
</XML>

And so on.

It is working perfectly, but how can I make SQL Server aware of the
fact that I changed (Adding expansions) the file without rebooting the
whole server?

As of now I can add all the changes, but the server doesn't recognize
tha new extensions until I reboot the machine. Why?

P
 
 
 

1. Sql Server 2005 Full Text Indexing on Sql Server 2000 compatible databases?

2. incomplete Full text index for large dbs in sql 2005??

we have created a full text catalogue on an Addresses table with exactly same
configuration on 3 databases. Two of them are on SQL 2005 and one on SQL 2000.

My Addresses table has 13 million rows and the full text was on the Full
Address column.

db is around 250GB

FT Index on SQL 2005 database was created very quickly (within 2 hours)
while SQL 2000 FT took 30 hours.

But my issue is SQL 2005 index does not contain all the words. For an
example following 2 queries gives me the exactly same number on the SQL 2000
database while on SQL 2005, first query only return 11 and the 2nd one 274
(274 is same on 2000 server/database as well)

SELECT count(*)

FROM [dbo].[Addresses]

WHERE CONTAINS(FullAddress, 'WARMINSTER')

GO

SELECT count(*)

FROM [dbo].[Addresses]

WHERE FullAddress like '%WARMINSTER%'

Is this a bug?

When i extracted the records which should have retrived in to a seperate
table (few hundred records) and created a FT index on that it works fine.


--
CTS DBA

3. Full Text in SQL 2005 vs SQL Express

4. SQL 2k5 FULL TEXT indexes: rebuild catalog vs. full repopulate of

5. Upgrading from SQL 2005 Express to full SQL 2005

6. Upgrading SQL 2005 Express to full SQL 2005

7. Upgrading from SQL 2005 Express to full SQL 2005

8. Installing MS SQL 2005 express with MS SQL express 2005 Full stand

9. Upgrading SQL 2005 Express to full SQL 2005

10. Trying to create a full text index (2005)

11. SQL 2008 - How to Enable Full-Text Index on Sql Server 2008 Table

12. SQL 2008 - How to Enable Full-Text Index on Sql Server 2008 T

13. Project 2003 and Full-Text Search / Full-Text Index

14. Consultant wanted for tuning full text searches with SQL 2005

15. CONTAINS full-text XML problem - for SQL Server 2005