Surely an easy question for those in the know... I have a contacts table, and I'd like to ensure uniqueness across first/middle/last name fields. Each field is an nvarchar(255) - as such, I can't create a regular index because the combined index size is greater than 900 bytes. I've briefly l...more >>

Hi All, We are experiencing a couple of strange issues with FTI/FTS. Our environment: W2K3x64 Clustered SQL 2005 SP 1(2 instances) 4GB Ram, Dual Proc, lots of disk. We have one table (currently 425,000 rows) that has a FTI on 6 columns, all VARCHAR columns. Change tracking is set to Manual...more >>

Hi I must be missing something obvious. I'd like to write a query that ranks the row containing the most unique keywords first, rather than the row with the most keywords. 1) my user enters "red green blue" 2) my query include somthing like freetexttable (xxx,xxx, 'red green blue' ) I ...more >>

I'm finding that using CONTAINS () and any word or phrase containing an ' does not work. It seems to split the phrase up instead of doing an EXACT MATCH search. example: searching on "computer's technology" the SQL looks like: SELECT DocTitle, Filename, Vpath, Size, Write, Characterization,...more >>

We are planning on renting a dedicated server for two of our web applications. I would appreciate it if someone could give us some advice on the server requirements in terms of the CPU and RAM. Here's our situation: Both these apps use Full Text Indexing on one column (varchar 255) in each da...more >>

Hi, I am using Microsoft FullText search feature in my database for Searching strings. I want to use CASE statement in CONTAINS. DECLARE @allowSearchALL int SELECT [ID] ,[Source] ,[Description],name FROM [Search] WHERE CONTAINS( Source , '"mail"') i know we can use CASE in W...more >>

Hi, I'd like to know if it's possible to implement the search '%word|phrase%' with full text catalog. I've tried with "...CONTAINS(FIELD,'"word|phrase"')" but I don't get the same result as using "... FIELD LIKE '%word|phrase%'". Full text search is faster than LIKE search but it return less ...more >>

Hi, For the past two weeks, we've been having MAJOR problems with the full text features of SQL 2005 on one particular server which is resulting in the hosted websites going offline at random intervals. These problems include (in approx order of how often they occur): 1. 100% CPU usage o...more >>

Hi, In SQL 2005 does anyone know what the difference between a full text catalogue "optimize" and a "populate" is? In 2000 I think there was only populate. It seems you can't schedule a normal "populate" in 2005 - only an "optimise". Nick......more >>

Ok I fixed the full text searching but now it wont update if I add a new record and try to do a freetext search on it nothing comes back ...more >>

Salutations All, I've searched far and wide, and am unable to find an IFilter implementation for Office 2007 documents. Does anyone know if one is forthcoming from Microsoft, if one is already out there and I'm just missing it, or if I need to just bite the bullet and write my own? Any assi...more >>

I would like to see if anyone knows what the prereq's are to install sql 2005 advanced and to be able to use the full text indexing capability. I have just a xp workstation. I have IIS running. I install full text per video 13 on microsofts education site but it does not work. if I run a search ...more >>

Hi, We've been using the catalog as part of our search engine for a year now. We use freetexttable to search for keywords and it is fine until now. For some reason the 'freetexttable' is inconsistent. I tried this query and I got a lot of rows. select * from tb_catalog where content like '...more >>

Hi all, Probably a complete FAQ/newbie question, but i'm not finding it (or searching wrongly). Suppose my user wants to do a search for two words, they want to do an AND-search and they don't want to type in AND. i.e. 'John Smith' should be 'John AND Smith' for CONTAINSTABLE to return any resu...more >>

Hi, I am using sql2000 server full-text search and neutral word braeker is set. I am having problem with noise words becouse the sql query returns with ignored word error. The sql query somethink like that SELECT title FROM tFtest WHERE contains (title,'"*nokia*" near "*phone*" near "...more >>

Hello, We are using SQL Server 2000 and we are doing Full-Text Indexing on a table that has 5 Text Columns (we have Full Text Indexing on these 5 columns). There are around 1.5 million records in this table. And the size of the Full-Text Catalog is around 1 GB. The performance issue we ...more >>

Hi I have a database containing artist names. When I try to do the fulltext, with artists having DOT's in the name, I can't find those. Example, if I search for "r.e.m" I won't get any results with select * from artists where contains(artistname,'r.e.m') if I do select * from artists...more >>

I want to see how it works and what is involved. I tried to find the item sampler application as described here: http://technet.microsoft.com/en-us/library/ms160844.aspx. But I cannot find it in my installation. Can someone help me out? thanks!...more >>

Hi, We're using Full text indexing on a couple of small databases (maybe 50mb each). Three times in the last week, I've had customers compain that their websites are unresponsive or have SQL timeout error messages when performing a search which uses FT. Logging on to the machine shows th...more >>

This query returns several rows: SELECT * FROM ContainsTable(Article, *, '"Working" AND "Women" AND "Healthy"') But this one returns none: SELECT * FROM ContainsTable(Article, *, '"Working" AND "Women" AND "Healthy" AND "Are"') I get the informational 'The full-text search condition...more >>

Hi, I have created an FTS index on a 53 milions lines table and the full population duration was about 4 weeks and 16 Gb on the Hdd. Is this behavior normal for this kind of size ? my server is a Windows Server Std 2003 with 4 Gb of Ram and 2*3Ghz HT Xeon with raid 5 hdd. Elian...more >>

Dear colleagues did anybody use sql turbo for fuzzy search , is it better than sql fuzzy search ? does fuzzy search use phonetci algorithm? what is the difference between FTS and SQL turbo I appreciate ur answers thx ...more >>