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 ...
|
Where is the FULLTEXTCATALOGPROPERTY(LogSize) log?
Thu, 27 Mar 2008 09:59:45 -0400
Where is the log full-text error log
FULLTEXTCATALOGPROPERTY('MyCatalogName', 'LogSize')
refers to in SQL Server?
"Size, in bytes, of the combined set of error logs associated with a
Microsoft® Search Service full-text catalog."
File somewhere?
Windows event log?
SQL Server Logs?
Keywords: FULLT ...
|
"near" search behavior changes with type change from nvarchar(max) to
xml
Wed, 26 Mar 2008 08:50:00 -0700 (PDT)
ran into the following case when using the near full text search
feature with SQL 2005:
The following string is stored in a table in an nvarchar(max) type
column and a full text index is built on it using english:
N'fireball word1 word1 word2 word3 word4 word5 word6 word7 waldcard
word9 word10 word11 word12 ...
|
ranking by most words found first? ISABOUT/WEIGHT/RANK?
Tue, 25 Mar 2008 10:50:55 -0700 (PDT)
This code does not appear to care that we have rows with both words vs
only one word...
select * from COLLABORATOR x inner join
containstable
(Collaborator,*,
' ISABOUT (
"hiv" weight (.5)
or
"gender" weight (.5)
)
'
)
as KEY_TBL
on x.ColId = KEY_TBL.[KEY]
order by rank desc
How can I make query ...
|
a problem related to full-text search
Tue, 18 Mar 2008 20:58:48 -0700 (PDT)
Hi all, I need a help for a problem related to full-text search.
Suppose I have Table A and Table B as following.
Table A
ID Data
-------------------------
1 W1 W2 W3
2 W2 W4
3 W3 W1 W5
4 W4 W5
Table B
ID Keyword
-------------------------
1 ...
|
searching across multiple columns
Tue, 18 Mar 2008 19:08:47 -0000
Hi
I've seen lots of posts on this subject but no satisfactory answers. I asked
the question in 2004 before SQL 2005 arrived so I wondered if there is a
neat solution to this problem now. I want a way to get return one row from
the query below.
CREATE TABLE Users
(
UID int IDENTITY(1000,1) PRIMARY KE ...
|
Re: SQL 2008 Full text indexing
Tue, 18 Mar 2008 13:29:49 +0000 (UTC)
Hello Mike C#,
See my series here http://sqlblogcasts.com/blogs/simons/archive/2008/02/20/SQL-Server-2008---iFTS-New-features-.aspx
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> "Jean-Pierre Riehl" <jean-pierre.riehl@bewise.fr> wrote in message
> news:4DA0019C-01EF-4718-BC6D-1660EC4 ...
|
|
|
Fulltext seems to be stopped
Fri, 14 Mar 2008 13:22:32 -0400
Hello,
2005 sql server on Win2003
SQL fulltext Queries (and stored procedures) all of a sudden have stopped
working. We are running these queries and sp's from a web site through an
ADO connection. Dynamic sql works fine.
I tried to restart the fulltext service, but it hung on the shutdown. I had
to ...
|
Is the Contains clause case sensitive?
Thu, 13 Mar 2008 17:50:12 -0400
Hi all...
Someone testing the Search program I am putting together brought this to my
attention today.
The Contains clause is:
contains((List_Name1),'("furniture" & "decor") and ("home" | "accessories")
&! "z24" &! "z-24"') )
Please note the &! "z24" portion.
The user showed me results where list names ...
|
Boolean search
Thu, 13 Mar 2008 10:33:28 +0100
Hi all!
This is my problem, I hope you can help me...
I have an asp web site.
I want to search, for exemple in a table of addresses, the string
"apple+table", to have all the record in my table where in a list of fields
(like name, address, telephon) there is the word apple and the word table.
How Can I perf ...
|
