Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





How To Configure Split Of Words In Full-text Search


By default MS FTS split text by space (' ').
How to configure it to split text by underline ('_') ?

Thanks




View Complete Forum Thread with Replies

Related Forum Messages:
Save Indexed Search Words (Index Full-text Search)
We have SQL Sever 2005 and created a Full-text Search on a one of our main tables. When some one comes for the first time and searches for "carb" it takes a long time to return results, but when the same search is done within a few more minutes, results return in less than 1 second.

Is there a setting in SQL Server 2005 to save all the indexes of searched words?

Thanks

View Replies !
Full-Text Search Without Certain Words
Hello,

I'm trying to create an SQL query that will search my full-text catalog for entries that do not contain certain words.

From http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_3syt.asp, if I'm reading this correctly, I can use the "AND NOT" boolean but not "NOT"

Basically I want something like this....

CONTAINSTABLE(T_Table, *, 'NOT FORMSOF(INFLECTIONAL, "hello world")')

but since "NOT" isn't an option, this doesnt work. Anyone know a good way to do this functionality?

Thanks in advance

View Replies !
Full-text Search Ignored Words
when I query the database with full-text search and I enter such keywords as eg "a", "an" I get this error message:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Execution of a full-text operation failed. A clause of the query contained only ignored words.

How can I filter out ignored words from the search? Is there a file where they are defined?

View Replies !
Noise Words In My Full-text Search Condition?
Does anyone see any noise words in this full-text searc query beingexecuting on MS SQL 2005?SELECT t.Title, t.Organisation, t.ID, t.OnlineStatusFROM Abstracts tWHERE t.StatusID=3AND CONTAINS ( t.ft, '( "acne") OR ("aeroallergen*") OR("allerg*") OR ("antihistamine*") OR ("atopic") OR ("corticotherapy")OR ("cyclosporin") OR ("derm*") OR ("dry skin") OR ("emollient*") OR("eczema") OR ("histamin*") OR ("hives") OR ("immunoglobulin E") OR("IgE") OR ("pruritis") OR ("psoriasis") OR ("rosacea") OR("seborrhea") OR ("skin") OR ("stem cell*") OR ("stem mast cell*") OR("utricaria") OR ("wart*" )' )AND t.DateOnline BETWEEN '11/12/06' AND DATEADD(dd, 8,'11/12/06')

View Replies !
Highlight Found Words Using Full Text Search
 

We are using fulltextsearch, with the FREETEXT command.
This works very well for us, but we would like to highlight all forms of matched words in the text.
This is used in a website, and now the highlighting of the found words is limited to the exact matches of the searched words.
So it often happens that in a text there is no exact match of the searched words, but another form of that word.
 
Does anyone know if and how this problem can be fixed ?
 

View Replies !
Does Full-text Search Could Count Words Occurrence
Hello,
I use the full-text search utility in SQL Server 2005 to find word in PDFs document.
This is my 'Documents' table:

id (PK), data (VarBinary(max)), extension (nvarchar(4))

My full-text catalog on 'data' column works fine because when I search 'Microsoft', my document containing this word is returned as result.

SELECT * FROM Documents WHERE freetext([data], 'Microsoft');
1 , 0x255044...., .pdf

But I need to know how many times 'Microsoft' word appears in this document.
Do you have any idea how can I retrieve this information?
Thanks in advance!

View Replies !
Does Full-text Search Could Count Words Occurrence Number
Hello,
I use the full-text search utility in SQL Server 2005 to find word in PDFs document.
This is my 'Documents' table:
id (PK), data (VarBinary(max)), extension (nvarchar(4))
My full-text catalog on 'data' column works fine because when I search 'Microsoft', my document containing this word is returned as result.

SELECT * FROM Documents WHERE freetext([data], 'Microsoft');
1 | 0x255044.... | .pdf

But I need to know how many times 'Microsoft' word appears in this document.
Do you have any idea how can I retrieve this information?
Thanks in advance!

View Replies !
Ignoring Noise Words In SQL 2005 Full Text Search
 

To ignore the noise words in the query microsoft remommends to execute the following statements, by which we can take advantage of the new transformation of noise words in CONTAINS queries: 
 
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'transform noise words', 1
GO
RECONFIGURE
GO
But this never works. Can any one please suggest how to make this work.(without modifying the full text text file)

View Replies !
Configure Full Text Search
I need to configure a full text search service (possibly with wildcards etc) on a SQL server. This is not my normal task, so I'm a bit in the blue. I've seen something about "contain" but don't know if I'm looking in the right direction. I should probably buy a good book, but in the mean time I thought let's try here! :)

View Replies !
Full Text Ignored Words
Is it possible to define seperate sets of noise words for different databases running on a shared server?

View Replies !
Ignored Words In Full Text Indexing
Hi,Just found out that this error can be solvedServer: Msg 7619, Level 16, State 1, Procedure usp_ft, Line 2A clause of the query contained only ignored words.triggered when executingSELECT TOP 1000 * FROM ADS JOIN ADSFULL ON ads_adid = fads_adidWHERE (ADS_ADID IN (SELECT FADS_ADID FROM ADSFULLWHERE (CONTAINS(*, '"opel" AND "and" AND "astra"'))))can be solved by changing the language specific file with noise words ...but that's not really an option in our server configuration.Now I wondered is there a way to query via TSQL a list of the noisewords ...so I can exclude them before parsing the query??I also dedected I can not catch the error in my stored procedure with theinstruction IF @@error ... So is it true that I can only handle this errorin my client software that calls the stored procedure??Thanks a lot.--Kind regards,Perre Van Wilrijk,Remove capitals to get my real email address,

View Replies !
Full Text Query With Noise Words (I Think)
Hope you can ignore your personal music tastes with this post!I have a table of Artists with a Full Text Index on a few columns on that table.  My full text querying against this table works really well apart from it seems for one band - "Take That"!  I'm guessing this is because these words consitute noise words? I parse user's search terms and add an "AND" between each word. So for example my query is essentially:select * from containstable(Artists, *, '"take AND that"') As I say, this works fine for Pink Floyd etc, but not for these guys!  So either SQL Server has a preference on boy bands or I am thinking it is because these words are deemed to be noise. Anybody got any tips on how I could tackle this?  I suppose it is quite possible that there might be another band with the same problem.I do have exclusive access to the SQL box, so perhaps I could edit the noise words file......Thanks 

View Replies !
Remove Ignored Words - Full Text Catalog
heywhen i try to search an "noise word" it drop me an ERRORwhat i have done : - stop full text service- remove the words i want ,from noise.enu , noise.eng , noise.dat (@@language = u.s...) the files is in system32 and in program files...config .- start full text service-rebuild and after that re populate the catalog
and it still drop me an ERROR !!! how can i resolve this prob ???
tnx tnx .

View Replies !
Disable Noise Words Checking In Full-text Query
how to completly disable noise words checking in full-text query?
(noise dictionaries already cleared!)

View Replies !
Error Message Generated When Noise Words Used In Full Text Query
I have been evaluating the Full-Test indexing feature of SQL Server 7, but I am getting an error message back for certain queries:

Server: Msg 7619, Level 16, State 1, Line 1
The query contained only ignored words.

If any of the words in the query is a noise word - e.g. The query

SELECT * FROM * WHERE CONTAINS (*,'tomato OR orange')

returns results, whereas the same query containing the noise word "under":

SELECT * FROM * WHERE CONTAINS (*,'tomato OR under OR orange')

returns the above error message

I had understood from the documentation that noise words such as these, which are not indexed, are ignored in a search - but it seems that they are not.

Surely one is not supposed to have to pre-process the query to remove any noise words found int he noise.* file??

Is there a fix to SQL server / Index server available?

Thanks in advance,

Denham

View Replies !
Help W/ Stored Procedure? - Full-text Search: Search Query Of Normalized Data
 Hi -  I'm short of SQL experience and hacking my way through creating a simple search feature for a personal project. I would be very grateful if anyone could help me out with writing a stored procedure. Problem: I have two tables with three columns indexed for full-text search. So far I have been able to successfully execute the following query returning matching row ids:  dbo.Search_Articles        @searchText varchar(150)        AS    SELECT ArticleID     FROM articles    WHERE CONTAINS(Description, @searchText) OR CONTAINS(Title, @searchText)    UNION    SELECT ArticleID     FROM article_pages    WHERE CONTAINS(Text, @searchText);        RETURN This returns the ArticleID for any articles or article_pages records where there is a text match. I ultimately need the stored procedure to return all columns from the articles table for matches and not just the StoryID. Seems like maybe I should try using some kind of JOIN on the result of the UNION above and the articles table? But I have so far been unable to figure out how to do this as I can't seem to declare a name for the result table of the UNION above. Perhaps there is another more eloquent solution? Thanks! Peter 

View Replies !
How Can I Search Throught DOCX (MS Word 2007) Documents By SQL Server 2005 Full Text Search Engine?
How can I search throught DOCX (MS Word 2007) documents by SQL Server 2005 Full Text Search engine?

Should I something download?

View Replies !
Full-Text Search: Prefix / Suffix Search
Please help me to create an SQL Server 2000 Stored Procedure for using prefix and suffix terms.

Example:

Say I want to find "Terminator" (1984).

I want to be able to use "Term" or "ator" as search results and still return the proper record.

Here is my Stored Procedure creation sql:


CREATE PROCEDURE sps_searchTitles(@searchTerm varchar(255)) AS
SELECT * FROM Video
WHERE FREETEXT (Video.*, '"*@searchTerm*"')
GO


--- The above does not appear to properly check both prefix ("Term---") and suffix ("---ator") terms.

I am trying to accomplish what is similarly done with LIKE '%term%'.

thanks, YM

View Replies !
Full Text Search- Substring Search Not Working
I have Sql server 2005 SP2.
I enabled it for Full Text search. Substring search where i enter *word* doesn't return any row.
I have a table testtable where description has word Extinguisher.

If i run a query with *ting* it doesn't return any row.
select * from testtable where contains(description,'"*xting*"') ;

But it works if i do
select * from testtable where contains(description,'"Exting*"') ;

The Full text search document says it supports substring search.
Is it an issue with sql server 2005?Please help.

View Replies !
SQL Server 2000 Full Text Search (extract Pieces Of Text)
Hello everyone !
I want to perform Full Text Search with SQL Server 2000. My documents (.doc, .xls, .txt, .pdf) are stored in a SQL Server field which is binary (the type of the column is image).
I would like to know, how you can extract pieces of text from the documents.
Example:
I have a ASPX page with codebehind in C# making the search in a table in SQL server that is full text indexed.
I make a search looking for the word "peace", than SQL server will take care about the search and return it to me the rows that match with that. But also I'd like to extract the 50 characters before and after where sql server found the word "peace" to show in the result page.
Does anyone has any idea how to work around it ?
 Best regards.
Yannick

View Replies !
Adding A Full Text Search Across Multiple Tables (with Text Fields)
Hi, i'm trying to do a full text search on my site to add a weighting score to my results.  I have the following database structure:
Documents: - DocumentID (int, PK) - Title (varchar) - Content (text) - CategoryID (int, FK)
Categories: - CategoryID (int, PK) - CategoryName (varchar)
I need to create a full text index which searches the Title, Content and CategoryName fields.  I figured since i needed to search the CategoryName field i would create an indexed view.  I tried to execute the following query:
CREATE VIEW vw_DocumentsWITH SCHEMABINDING ASSELECT dbo.Documents.DocumentID, dbo.Documents.Title, dbo.Documents.[Content], dbo.Documents.CategoryID, dbo.Categories.CategoryNameFROM dbo.Categories INNER JOIN dbo.Documents ON dbo.Categories.CategoryID = dbo.Documents.CategoryID
GOCREATE UNIQUE CLUSTERED INDEX vw_DocumentsIndexON vw_Documents(DocumentID)
But this gave me the error:
Cannot create index on view 'dbname.dbo.vw_Documents'. It contains text, ntext, image or xml columns.
I tried converting the Content to a varchar(max) within my view but it still didn't like.
Appreciate if someone can tell me how this can be done as surely what i'm trying to do is not ground breaking.

View Replies !
Full Text Search Vs LIKE Search
Are there any big differences between the two search techniques? It seems like they are both very similar.

SELECT * FROM TABLE1 WHERE TEXTFIELD1 LIKE '%DATABASES%'
SELECT * FROM TABLE1 WHERE CONTAINS (TEXTFIELD1 ,' "DATABASES" ')

View Replies !
Full-Text Search
Hello !
With SQL Server Management Studio Express I have created a catalog and a index.Here is the code :
create fulltext catalog myfirstcatalogcreate unique index myfirstindex on northwind.dbo.customers(companyname)create fulltext index on northwind.dbo.customers(companyname)key index myfirstindex ON myfirstcatalogWITH CHANGE_TRACKING AUTO  
With SQL Server Management Studio Express and the following command the full text search is working fine.
select companynamefrom northwind.dbo.customerswhere contains(companyname, ' "blauer" ') 
I have a big problem :
When I try to use this database (NOTRHWIND.MDF) into my .aspx file with VWD 2008 I get an error :
Cannot use full-text search in user instance.
 
Can you tell me what can I do to make use of full-text search inside my aspx pages ?
Thank You !

View Replies !
Search Text Full
hi all.i want to search, for example :"test string" in database :  table have column(name) , i want to search all rows with  column(name) is "test " or "string" or "test string"i don't want to use(full text search of sqlserver 2005 ) can i help me.thanks in advance 

View Replies !
Full Text Search Help
 Hi I have a full text index on my product table. When I do a search for Record, it returns all values for Record and Records.Now If I do a search with a spelling mistake say Recod . it doen't return anything.How can I get the full text to return my query even if there is a spelling mistake ? Thanks  My query:SELECT *  From Product        WHERE FREETEXT (description, @SearchString)

View Replies !
Full-Text-Search
Hi friends
i work with sql server 2005 express(Management Studio)
can i use full text search service with that edition of sql server?
and how i can use that.
thank u.

View Replies !
Full Text Search
I am asking about installing Microsoft Search service in SQL Server 2000 in Windows XP Professional
Is that possible?
And By the way it's not possible for me to switch to SQL Server 2005 that I know that full text indexing already exists in it
 
thanks

View Replies !
SQL Full Text Search
Does anyone know how to use SQL Full Test Search with ASP.NET?

View Replies !
Help With Full-text Search
MSSQL server database contains the projects table that allow full-textsearch.I search projects with name that contains exact phrase 'Project 2':SELECT * FROM projects WHERE CONTAINS(projects.name,N'("Project 2")'))but results contain projects with names "Project 1", "Project 2","Project 3"What is correct 2nd CONTAINS() function parameter for searching"Project 2" only?

View Replies !
Full Text Search
Hi everyone

I am using SQL server 2000 with SP3 on Windows 2003 server.

I have scheduled a job to populate a full text index incrementally. Everytime it runs the job to populate the index table it writes some messages into event log.
Like this:
1.
Event Type : Information
Event Source : Microsoft Search
Event Category: Gatherer
Event ID : 3019
Date :8/7/2004
Time :2:21:00 PM
User : N/A
Computer : ARC-03-DEV
Description:1
The crawl on project <SQL Server SQL00002000009> has started.

2.
Event Type : Information
Event Source : Microsoft Search
Event Category: Gatherer
Event ID : 3047
Date :8/7/2004
Time :2:21:00 PM
User : N/A
Computer : ARC-03-DEV
Description:
The end of the incremental crawl for project <SQL Server SQL00002000009> has been detected. The Gatherer successfully processed 998 documents totaling 0K. It failed to filter 0 documents. 998 documents were modified. 0 URLs could not be reached or were denied access.

The event log is getting filled frequently.

Is there any way to stop this messages?
It is normal for Microsoft Search to write this message into EventLog?
Even though there is no chanage in the database it give the above messages.

Any one know the reason please help.

Quick reply is appreaciated.

Reagrda,

Atiq Rahman

View Replies !
Full Text Search
Hi,
We have a windows 2003 server (standalone) running SQL server 2000. We need to enable full text search on the database available in it. We have already added full text search in the installation and the option is available but when we try to create a full text catalog on any of the databases, it crashes ie., doesnot respond and gives the typical 'report to microsoft window'. We need to restart the SQL server after the same. can someone help us out.
Thanks
Smith

View Replies !
Full Text Search
Hi

This is Yogesh Jangam
I m using SQL Server 7.0 and ASP for an intranet application
I am using Full Text Search feature os SQl 7.0.

The problem is i am not sure where to populate my Catalog which i am using for searching Articles. Basically, Various writers will be submiting, approving Articles which can then be searched by other users to be read or referenced

i was thinking to populate full or incremental, once an Article is approved, but i think it is time and resource consuming


any way

suggest me!!

View Replies !
SQL Full Text Search
Hi.

We are having a problem with full text search.

Our server has recently been down graded from enterpise to standard eddition SP3.

I have reset the SQL Service account to local admin using enterpise manager but when i try to populate the full text catalogue I get an item count of 0.

I have reregistered all dlls in the mssearchin directory and the language key in HKLMsoftwaremicorsoftsearch1.0eutral doesn't exist.

Both the MSSearch and SQL services are running under the local admin account, and the builtadministrators account is a sysadmin.

Any help will be much apreciated.. pulling my hair out on this one.

View Replies !
Full-Text-Search
Hi,
I have a full-text search enabled table and an image data type column that stores the extracts from the documents stored in the files. I have created a full text catalog that indexes few columns in the table and image data type column as well and I assigned the extension column to this image data type column.
Everything works fine except that search on the image data type column called, in my case "body" does not return anything. The documents exist, there is an information in the "body" column.

My code goes like this:
select FT_TBL.resourceID, FT_TBL.lang, FT_TBL.keywords, FT_TBL.description, FT_TBL.extension, b.rank
from full_text_search as FT_TBL inner join containstable(full_text_search, *, 'Microsoft') as b
on b.[key] = FT_TBL.resourceID
order by b.rank desc

any help appreciated,
thanks

View Replies !
Full-text Search
How can I make a full-text search in an image columns ?

View Replies !
Full Text Search
hi, I just added Full text search in sql server 2000 installation. I tried to create a full text searh at employee table in the pubs database, at the final stage, IT froze on me. then when I checked the Window Task Manager Performance table, the mssearch.exe was taking 98% of the CPU. I had to reboot the server. then I installed teh fulltext search in another server box and get he same the same thing,but this time the cpu was a t 50%... Am I missing any steps that I need to do or configure sql server to be able to utilize a full text search.... Please advice....

Thanks
Ali

View Replies !
Full Text Search
I am using a full text index search on SQL 2000 and need to rate the results by percentage. Can anyone give me any guidance on how to translate the search results into percentages?

Thanks in advance--Mike

View Replies !
Full-text Search
Hi, I got a problem in my SQL2000 server full-text search function. When I created the full-text catalog and index on tables, I got the message showing it is successful. But when I checked the properties of the catalog, I found "item count" is zero. Apparently, it didn't populate any data into index. What could the possible reason be? Any idea? I appreciate your comments.

Diego

View Replies !
Full-Text Search
I am trying to create a full text catalog for a database (using SQL Server 7.0 beta 3 eval copy). I am unable to create because of the error:
"Could not load the full-text search component-SQLFTQRY.DLL"
Does anyone know if there are limitations on the eval for full-text searching? I do not have the required .dll, possibily the install was not 100%?

View Replies !
Full-Text Search
I have enabled a table for Full-Text-Search and i´m looking for sample code (stored Procedures). The table contains Products like:
Milk, Honey, Milk with honey, chocolate, nuts, chocolate with nuts, oranges, etc.
the input comes from a webpage where users can search for products.
How do i manage my stategy if a user puts only 1 letter or parts of words in the inputbox?
thank you

View Replies !
SQL Full Text Search
Greetings ! Has anyone seen a problem in SQL 7 where you create a full text catalog, define an index on a table, and run 'populate', and end up with an empty catalog ? It runs for a while during the population, and there are no messages in the logs, but the 'item count' property of the catalog is 0.
Also you can run a query that uses the index (i.e. uses 'CONTAINS') and you receive no error, and no results.
I've set this up on other servers, so I know it works, but can find no mention of this problem anywhere.

TIA

Eric

View Replies !
Full Text Search
The full text search is great in SQLS7, but how can you turn off the microsoft word list that says 'error: too generic of a search'????


je

View Replies !
Full Text Search
I am not having any luck setting up Full text search. I am using SQL 7 with sp2 on an NT server with service pack 6. I can set up the catalog with no problem but when I try to populate the catalog, I am getting the following error in the NT event viewer:

One or more warnings or errors for Gatherer project <SQLServer SQL0000600005> logged to file <d:MSSQL7FTDATASQLServerGatherLogsSQL0000600005.2.g thr>.

Unable to access crawl seed <MSSQL://LOCALHOST/6.341576255> in project <SQLServer SQL0000600005>. Error: 80072ee2 - The operation timed out.

Unable to start crawl for project <SQLServer SQL0000600005>. No crawl seeds could be accessed.

Detected end of crawl for project <SQLServer SQL0000600005>. Successfully processed 0 documents, 0K. Failed to filter 1 documents.

Does anyone know how to correct this problem?
Thanks
Terry

View Replies !
Full Text Search
Hi,

My Prod. server is having SQL Server 7.0 with SP2 installed. I am planning to install Full Text Search component. I know I have to run setup and select Full Text Search from Server Components. But, Do I have to re-install service pack 2 after this ? What are the other concerns in, such modifications to the existing SQL installation ?

Thanks

View Replies !
Full-Text Search
Hi,

When I am trying to start 'Full-text indexing wizrd', it is throwing me the error 'Full-text server service needs to be running in order to open this wizard'. But, I have Full-text search components installed along with My SQL Server 7.0 Ent. Edition and the 'Microsoft Search' service is running.
Can anybody guess, what could be wrong?

View Replies !
FULL TEXT SEARCH
I have defined full-text indexing on a table a couple of months ago and the catalog was fully populated, it was working fine until now. But suddenly has stopped working, I have been scheduling incremental population on a regular basis and also have tried to remove and redefined full-text indexing but can't get it to work.

Can anyone help please

View Replies !
FULL TEXT SEARCH
I have a table which is defined for full-text indexing and the catalog was fully populated, it was working fine at first, i checked it a couple of weeks after and doesn't seem to work. I have been scheduling incremental population on a regular basis, I have tried rebuilding the catalog and also have tried to remove and redefined full-text indexing but can't get it to work.

Does anyone know what may be causing this to stop working?

thanks in advanced

View Replies !
Full Text Search
Hi Gurus.

Is there anyway that i can do a Full text search query on multiple tables.

I am trying to achieve something like this.

select * from table1,table2,table3 where contains (*,'isabout("SWYNK Threads*")')

SQL allows me to do the search query only for one table. I have to write procedure to put multiple select queries for each tables. Is there any other way i can do a search on all table i have in Full text catalog.

Any suggestions and comments are welcome.

Please advice.
-MAK

View Replies !
Full Text Search
After following all of the steps in Swynk's Guide to Full Text Search, I still can't seem to retrieve any records from the full-text search. I get messages saying that I created the Index correctly and that I successfully populated the catalog. But when I View the Properties of the catalog, the Unique Word Count = 1 (but there are thousands of words in the table).
I know that there is a record with the word "help" in one of the full-text indexed columns, but when I call Contains(column-name, 'help'), I recieve an empty recordset.

Does anyone have any suggestion on what I can try next?

Thanks for any help,
Arthur

View Replies !
Full Text Search
I have set up a Full Text Catalog in sql2k on one of my tables which holds a list of adverts and keywords associated with each advert.
On the search page of my website the user will enter some keywords to search upon. I am trying to determine the advert most relevant to those keywords to display.
I have this query so far


select [key], [rank]as rank, b.Keywords
from tbl_BANNER_ADVERTS as b
join CONTAINSTABLE
(tbl_BANNER_ADVERTS, keywords, 'ISABOUT (asp WEIGHT(0.9),sql WEIGHT(0.9),java WEIGHT(0.9))') as k
ONb.BannerPK = k.[KEY]
group by [Key], rank, Keywords
order by rank desc

but am getting these results back

keyrankKeywords
1476oracle java asp
1543java oracle asp
1143asp sql html
1330asp html java
1211sql oracle html

What I dont understand is why 14 is above 15 when both contain asp and java (which im looking for) and oracle which im not. Also why isnt 11 and 13 the same ranking as they both match 2 words as well. Ive given them all equal weight so should they not treat each word the same.
How can I get it so that the banners that match the most keywords entered by the user come above the others.
I just want the banners which match the most words to be scored highest. If one advert has 2 words and another has 2 different words I want both with equal ranking so I can then randomly choose between them.
I don't care about the order they are entered or the proximity of one word to another or the length of the word. All words should be treated equally and the advert with the most matches should be top.

Any help would be much appreciated and I thank you in advance.

View Replies !
Full Text Search
Hi all,

Currently I am trying to rewrite a query that performs the followings:

1. Read all persons from table Persons and return all the details;

2. Query primary tries to filter out invalid email addresses and any email address exist in the unsubscribe table.

3. The query need to identify if the email address are valid through following conditions:


a. email address should contain patter like %@%.%

b. email address should not contain like unknown.com or none.com etc
Hence the simple query would be:
SELECT *
FROM Persons
WHERE Email NOT LIKE ('%@%.%','unknown.com','none.com')
AND Email NOT IN (SELECT Email FROM UNSUBSCRIBE)
This query returns a subtential amount of rows and sometimes very resource hungry.
I am currently trying to substitute it with full text index, as my primary concern is to improve its performance.
Currently I do have the following indexes:

1. Persons table : Cluster index on PersonID



  Non Unique index on Person(Email)
  Full text index on Person(Email)
Now my problem is I was not able to write subquery in the containstable operator to get rid of all the unwanted email addresses at once.
Any suggession what could be the best way to tune this process.
Thanks in advance.
 


 

View Replies !
Full Text Search 'Near'
using SQL server 2005 I have a table which has full text search index enabled

when I run a search using the 'Near' option it returns rows which meet the criteria, how ever the criteria are not 'near' each other they are several hundred words apart.

 

What is the problem

 

How near is near

 

thanks in advance

 

Glyn

View Replies !

Copyright © 2005-08 www.BigResource.com, All rights reserved