Hi all, In my case, I build a full text search query. like "select * from _tt_fields where contains(string,'"development group"')", when I click F5 then execute the sql, it returned the records, but when I click execute the query more than 4 times, it does not return anything! From http://www.dev...more >>

Hello - I have several different "content" types (articles, audios, videos, etc.) that have a parent->child relationship structure in my SQL Server 2005 DB. The parent table is called Content and all the common fields to these items are contained within it (e.g. title, name, description). ...more >>

Hi! I've got a table SupplierItem with full text catalogue set up on it and I need to search two columns of it, Description2 and SupplierItemCode, for any combination of terms entered in any order with wildcards (ie if user puts in FOLDER, it finds FOLDERS as well) and also search for two co...more >>

What do you mean by it doesn't work? Are you able to find anything? Are there any error messages? -- RelevantNoise.com - dedicated to mining blogs for business intelligence. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Ser...more >>

Is 1 in your noise word list? -- RelevantNoise.com - dedicated to mining blogs for business intelligence. 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 <in da club> wrote in me...more >>

in wrote on Wed, 31 Oct 2007 17:11:39 +0200: > I have query like that > SELECT > Urun_ID > ,Urun_Ad > FROM TBL_URUNLER > WHERE CONTAINS(Urun_Ad, '"*mta1000-*"' ) Why are you using *? It doesn't work like that - FTS breaks up the indexed columns into words, you can use a * at the end ...more >>

I have query like that SELECT Urun_ID ,Urun_Ad FROM TBL_URUNLER WHERE CONTAINS(Urun_Ad, '"*mta1000-*"' ) it returns 62 MTA1000-1 When i chance the search phrase mta1000-1 it returns nothing. Urun_Ad is defined as NVARCHAR(50) in my tbl_urunler tabl...more >>

Hi Simon Sabin, Thanks for you reply. How about this implementation... SELECT [ID] ,[Source] ,[Description], name FROM [Search] WHERE (@allowSearchALL = 1) OR CONTAINS( Source , 'mail') Pls suggest if this option is fine? will there be any performance hit ..if i use the above query?...more >>

Hi I am using SQL Server 2005 Express for full text search. I have created catalouge and fultext index on the database and table. I checked all the properties of the full text index using the queries. select * from sys.fulltext_indexes and everything seems to be fine. But I am not getting a...more >>

´ÚÃÄ!!!!!!!!¾¾ºÒ³âµå¾Æ ´Ï¹ÌÁ½ÀÌ´Ù¤»¤»¤» ...more >>

Thanks for the tip. Found information on including non-key columns in non-clustered indexes in books online; methinks this is what I was looking for. Remi. ...more >>

You could where you would do a check to see if the combination field exists and if not enter it. You will probably find that plain old non-clustered indexes will work better here, or even an indexed view. With SQL 2005 use the include option when creating your indexes. -- RelevantNoise.co...more >>

Full indexing only makes sense when a large portion of your datachanges at any one time. Incremental populations can sometimes work better than full depending on the amount of data deleted. For example if its 90% full would probably work better, if its 20% incremental could, if its smaller tha...more >>

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 >>

On Oct 24, 11:41 pm, "Hilary Cotter" <hilary.cot...@gmail.com> wrote: > When doing a big delete you should set change tracking to scheduled mode > instead of index in background. You might also find that a full-population > might work faster than change tracking. This will stop/minimize your lock...more >>

Get a high speed disk subsystem, preferably with 10 or more high speed disks in a single raid 5 array for your catalog. We are running a 3 terabyte sql fts search application on a single DL 585 quad, with 8 Gigs of RAM, 3 Ghz. -- RelevantNoise.com - dedicated to mining blogs for business in...more >>

When doing a big delete you should set change tracking to scheduled mode instead of index in background. You might also find that a full-population might work faster than change tracking. This will stop/minimize your locking problems. I am not sure what is causing the timeouts. It could be ...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 >>

Hello Vijay, Daniel is correct. You don't have that option. You best solution from a performance perspective is to use dyanmic SQL and only add the criteria you need and then execute that. Make sure you use sp_executesql and parameterise your query. i.e. declare @sql nvarchar(max) de...more >>

Hello I'm afraid it is right. Thats how the ranking is supposed to work. Unfortunately there is no hitcount mechanism in full text to be able to rank in the way you want. Simon Sabin SQL Server MVP http://sqlblogcasts.com/blogs/simons > Hi > > I must be missing something obviou...more >>

Hi Bryan You have 2 options (sort of) Install Office 2007 on your server and then issue an sp_fulltext_service 'load_os_resource', 1 to load the iFilters The second option isn't available yet, but there will be an ifilter pack made available for Office 2007. Simon Sabin SQL Serv...more >>

This is an indexing services question and an NT 4.0 Index Server 1 one at that. To make your query Windows 200X Indexing Services 2.0 compliant you must do this: SELECT DocTitle, Filename, Vpath, Size, Write, Characterization, Rank FROM SCOPE() WHERE CONTAINS ('"computer''s technology"') ...more >>

ok, changed my code back SQL now looks like: SELECT DocTitle, Filename, Vpath, Size, Write, Characterization, Rank FROM SCOPE() WHERE CONTAINS ('"computer''s hardware"') AND (Filename LIKE '%_%_%_%.pdf') still returns the wrong results. >.< i was hoping that was the issue >.< On Oc...more >>

I tried this idea before and go the same responses, pdf files with either the word computer or the word technonolgy in them. NOT files with the phrase "computer's technology" in them. enumeration? how would this help and how would i turn it on? On Oct 24, 12:22 pm, "Hilary Cotter" <hilary.c...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 donot want to use Multiple IF blocks as my IF criterias are huge...i want to use some thing like SELECT [ID] ,[Source] ,[Description],name FROM [Search] WHERE Source = CASE WHEN @allowSearchALL = 1 THEN Source ELSE 'mail' END "Hilary Cotter" wrote: > You need an if stateme...more >>

Vijay wrote on Tue, 23 Oct 2007 00:34:09 -0700: > Hi, > I donot want to use Multiple IF blocks as my IF criterias are huge...i > want to use some thing like > SELECT [ID] ,[Source] ,[Description],name > FROM [Search] > WHERE Source = CASE WHEN @allowSearchALL = 1 THEN Source ELSE 'mai...more >>

Hilary wrote on Mon, 22 Oct 2007 20:55:24 -0400: > also SQL FTS will throw out the middle character. It knows something is > there, but not what. So it will match on > word!phrase word$phrase and word phrase amoung others. I think the word|phrase wasn't an explicit string, rather the | re...more >>