'%phrase%' search
Mon, 22 Oct 2007 03:12:00 -0700
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 rows.
Thanks ...
|
Major full-text related problem!
Fri, 19 Oct 2007 16:14:17 +0100
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 on both processors ...
|
FT Catalog "optimise" or "populate" differences
Fri, 19 Oct 2007 12:04:51 +0100
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... ...
|
full text update
Thu, 18 Oct 2007 14:04:08 -0700
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
...
|
IFilter for Office 2007 Documents?
Thu, 18 Oct 2007 10:46:47 -0700
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 assistance anyone can ...
|
SQL Server 2005 with advanced services and full text search
Thu, 18 Oct 2007 05:26:59 -0700
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 using contains or ...
|
Re: SQL Server Full-Text Search Performance
Mon, 15 Oct 2007 22:53:49 +0000 (UTC)
Hello Hilary,
Katmai is being launched in Feb 2008 but won't go to RTM until later in the
year.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> No, one catalog per table partition or unpartitioned.
>
> I have no stats for comparison's between Lucene4DB or SQL Server.
>
> Katmai ...
|
|
|
Re: msftesql.exe uses 100% on all CPUs
Mon, 15 Oct 2007 09:56:50 +0100
Hi Hilary,
Sorry for the delay. I'm not sure what an iFilter is, so I'll get back
to you on this. I haven't knowingly used one at all!
Nick...
Hilary Cotter wrote:
> which iFilters are you using?
> ...
|
freetexttable bug
Fri, 12 Oct 2007 15:15:41 -0000
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 '%AT&T%'
When I ...
|
Allowing the omission of 'AND'
Thu, 11 Oct 2007 01:35:13 -0700
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 results,
but the use ...
|
