Tagged Questions

2
votes
1answer
111 views

What characters are word breakers in English for SQL Server 2005 and 2008 R2?

I can find what DLL supports English word breakers by using sp_help_fulltext_system_components but I have not been able to find an actual list of the word breaking characters for English (like blank, ...
2
votes
1answer
148 views

SQL Server 2005: Full-text search on a multi-lingual table

I have an articles table as follows. +-----------+--------------+---------+ | uid | int | PRIMARY | | articleId | int | UNIQUE | | lang | varchar(2) | UNIQUE | | ...
3
votes
2answers
210 views

SQL Server 2005: Full-text search space requirements

Is there a way to calculate the physical drive space required for a full-text search catalog? Space is cheap, but I'd like to know what I'm getting into. I'm looking at a table of about 200 articles ...
1
vote
1answer
44 views

SQL Server 2005: Full-text search catalog design

I'm new to full-text searches, and am curious about how to properly design the full-text catalogs. I have an "articles" table. I would like to do full-text search on both the "title" and the "body" ...
2
votes
1answer
59 views

Full Text search returns duplicate keys

I have a search like the example below. The problem is that the result returns a key muliple times if the term "beach" is in myTextColumn multiple times, for example "I went to the beach because the ...
3
votes
1answer
249 views

Full-text index in partitioned table

I have a table with just over a million records with a full-text index. This table has been split in two in the past, and the data older than a certain date is moved to another table with the exact ...
2
votes
2answers
325 views

Should SQL full text search match the value test2 when searching for test?

if i have table data that is indexed using full text search in Microsoft SQL server 2005 that includes raw table data such as "test2" should a query using FTS find a match if the search string is ...
2
votes
1answer
219 views

Why doesn't FTS match any records?

I created an indexed view with a few fields that i created a full text search based on these fields. here is my view: alter VIEW vFullTextSearch WITH SCHEMABINDING AS SELECT M.Id as MessageId, ...
5
votes
1answer
1k views

How to install SQL Server Express 2005 with Full text search

I am in need to Install SQL server 2005 Express edition with Full Text Search capability. I don't know what to download and the order of installing the Database management system. Could someone ...