|
|
|
Benchmark for Full Text Search
Tue, 15 Apr 2008 14:16:01 -0700
Hi,
We are currently using a 3rd party Search Engine to search our application
content in SQL server.
Could someone please point me to Benchmark data for the FTS service? I am
interested in switching to FTS even if the Performance numbers are comparable
or better.
thanks for any help!
regards,
Anku ...
|
Special Characters
Tue, 15 Apr 2008 09:34:05 -0700
A very simple question about the difference in behaviour between 2000 and
2005 fti:
the following search in a parts catalog works in SQLServer 2000
select count(1)
from dbo.partsdescription
where contains(*,'15"')
but returns Msg 7630 syntax error near '"' in the full-text search condition
'15"'
Wh ...
|
¹ØÓÚÈ«ÎļìË÷ÖеÄÎÊÌâ
Mon, 14 Apr 2008 15:10:06 +0800
Dears£¬
ÎÒÃÇÔÚʹÓÃMS SQL ServerÈ«ÎļìË÷ʱ£¬Åöµ½ÈçÏÂÎÊÌ⣬Çë¸÷λ´óÏÀ½âÊÍÒ»ÏÂÔÒò¡£
ÎÒÃÇ·Ö±ðÓá°Æ·Î»¡±ºÍ¡°Æ·¡±²éѯij¸ötextÊý¾ÝÀàÐÍ£¬·¢ÏÖ½á¹ûºÜÆæ¹Ö¡£
²éѯÌõ¼þ£½¡°Æ·Î»¡±£¬ÔÚ½á¹ûÖп´µ½¸ÃÒ»±Ê¼Ç¼ÈçÏ£º
Code£½A0000251£¬Name£½Éç½»³¡-2£¬TextÄÚÈÝƬ¶Î£½¡°¡¡Í¬Ê±Ò²°ÑÒ»ÕÅÓÐƷλµÄ²Í×ÀÍÆÏòÁËÈ«Å·ÖÞ£¬¡¡¡±
SQLÓï¾äÈçÏ ...
|
Cannot search FTI on certain common words (the, like, and, to, etc.)
Wed, 9 Apr 2008 01:07:46 -0700 (PDT)
As the title says, I'm having problems returning results when the
search string contains any of the words in the list in the title.
I'm damned if I can work out why this is happening, as my noise words
file is empty, and anyway, the search returns no results, even if
there are other words in search string - e. ...
|
Full text index - migration
Tue, 8 Apr 2008 11:26:04 -0700
What is the easiest way to migrate full text indexes from SQL2K to SQL2K5? ...
|
help,a text how to sql table code ?
Sat, 5 Apr 2008 15:28:01 -0700
help,a text how to sql table code ?
i have a text as follow, line with ¡°|¡±and {LF},
8|-000000186075919.|+000000000387820.|2008-03-31|20010423|
9|-000000000003919.|-000000000123620.|2008-03-31|20010123|
8|-000000018623419.|+000000000381230.|2008-05-30|20010423|
i want to sign char(1)£¬year decim ...
|
Is this only way??
Wed, 2 Apr 2008 12:33:00 -0700
Hi,
I use SQL 2005 FTS.
My requirement is to highlight the search terms.
As you guys probably know, I can't simple use replace method for the search
term to highlight, becuase of lemmatizer and stemmer.
So one thing I could think of is if SQL server returns position data for the
search terms.....I mean ...
|
|
|
Containstable with Top_n_by_rank returning less than expected rows.
Wed, 2 Apr 2008 06:40:19 -0700 (PDT)
Hello,
I've got a full text index, with an empty noise word file. The table
has only 1 column + 1 timestamp for doing incremental updates (data
changes only once a day, in 1 time). Change Tracking is disabled
(OFF). SQL version is 2005 SP2 (9.0.3054)
From time to time (after a few days), ContainsTable queri ...
|
International English FTS would be very desirable...
Mon, 31 Mar 2008 00:32:53 -0500
Many of my customers have sites in both the US and UK or Australia/New
Zealand.
Thus, when one location searches for "colour", it would be really nice if
they also found things with "color".
That could be handled with a Thesaurus entry.
But some things would be better handled with an extended definition of ...
|
Anyone use a full sized Thesaurus? Is performance hideous?
Sun, 30 Mar 2008 11:03:06 -0500
The FORMSOF(THESAURUS, xxx) feature seems cool.
But I've done a LOT of searching the web, and have found nothing but toy
Thesaurus for SQL Server.
I can't find a full English Thesaurus anywhere. Neither US or UK...
let alone, what I'd want, which is an International one that knows "color"
and "colour" are sy ...
|
|
|
