|
FullText Search data model for speed
Which method is faster for full-text search
One row big varchar field
comment VARCHAR(1000)
on lots of small varchar fieds
like 10 rows comment VARCHAR(100)
--
Message posted via http://www.sqlmonster.com ...
Thu, 13 Jan 2005 15:47:51 GMT
|
Proper Nouns
Hi All,
We are using a FORMSOF(INFLECTIONAL) query and trying to establish why we
get results returned for a search on "Luke" but no results for "Lukes"?
Whereas "Rebuke" and "Rebukes" returns the same number of results.
Is there a dictionary or similar that we can add to to ensure that plural
forms of ...
Tue, 11 Jan 2005 02:01:03 -0800
|
New to SQL server full text search
Hi,
I'm trying to install MS SQL server 2000 full text search. I have two questions:
1) Many of the documents are scanned images wrapped as PDF files. Do I need to install Adobe IFilter to index these documents?
2) Some of these documents are 160MB in size. Would MS SQL server be able to index these?
...
Mon, 10 Jan 2005 13:07:55 -0800
|
Indexing image - file size limit?
According to the Books Online information on full-text indexing, there
are limits on the size of a file that can be indexed in an image
column: 16MB filesize, 256 KB of filtered text. I've exceeded those
limits in my testing (with Word docs), and still appear to be able to
access information in those files with ...
10 Jan 2005 07:32:00 -0800
|
MSSearch without SQL Server
John,
The "raw text" recides in files, e-mails etc. stored in NTFS and Exchange Server.
Thanks for the links, I will check them out.
Regards,
Thomas ...
10 Jan 2005 00:10:43 -0800
|
Data Matching
Dear All,
Firstly I know my question may be not perfectly fit in this newsgroup, but I
hope I find some assistance or guidance,
we have the customers data in different 3 systems (CRM,ERP, another Custom
developed system) , we are now going to assign a unique customer id across
all these systems, all the ...
Sun, 9 Jan 2005 19:24:32 +0200
|
Fulltext search won't repopulate when running on batteries
Here's one that had me stumped for a good couple of hours.
While working on my laptop, I was trying to rebuild a fulltext search
catalog. I tried numerous times repopulating, deleting and rebuilding.
whenever I tried to start it populating, I got messages in the event
log saying the crawl had started, but no ...
9 Jan 2005 02:19:28 -0800
|
Full-Text Installation Problem
I am having a problem with SQL Server 2000 Developer Version and Microsoft
Search on Windows XP. Microsoft Search did not appear in SQL Server Service
Manager. I ran SQL Server 2000 setup and found that the Microsoft Search
component was not installed so I installed it. I am not sure how that
happened. I th ...
Sat, 8 Jan 2005 23:13:01 -0800
|
MSSearch without SQL Server
We are using MSSearch via SQL Server to perform free-text searches.
However, we would rather not store the entire raw text in the SQL
Server. So is there a way to use the MSSearch service outside the
context of SQL Server? In other words, to populate MSSearch directly
with free-text, let it build its index a ...
7 Jan 2005 07:17:09 -0800
|
Freetext Search - SQL CONTAINS (column,"R-483*") FAILS
Hi
I would like to search for "R-483" phase using SQL CONTAINS
function :
DECLARE @i_FreeText Varchar(255)
SET @i_FreeText= '"r-483*"'
SELECT TOP 10 * from iBlockFreeText
where
(@i_FreeText is null or contains(iBlockFreeText.Content,
@i_FreeText))
, but it fails. It's okay when i use
...
7 Jan 2005 04:14:12 -0800
|
Problem Transact-SQL Statement
I've come across a Transact-SQL statement as follows:
-- Statements start here
select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from
sysobjects where type = 'U'
-- end here
Questions:
(1) How should the 'select' statement be interpreted?
(2) What are the rules for using the quotati ...
Fri, 7 Jan 2005 00:54:25 +0800
|
Full text Search
Hi,
I'm in the process of implementing a full text search service using MS SQL server 2000. Can anyone point me to some materials, books/websites that I could browse before I start my work?
Appreciate your reply.
Anantha
**********************************************************************
Sent v ...
Wed, 05 Jan 2005 08:50:13 -0800
|
Character Problems
The spesific characters of turkish alphabets ->>iD C
Wed, 5 Jan 2005 07:05:02 -0800
|
Adding PDF indexing with Sql Server 2005
I am trying to use the full-text indexes with Sql Server 2005, and wanted to
index pdf files. I have downloaded and installed the Adobe PDF iFilter from
Adobe, and have tested it using the iFiltTst on a directory with PDF files.
It does index the pdf files.
I then moved the files into a sql server table i ...
Mon, 3 Jan 2005 10:56:59 -0800
|
Set up FTDATA on Failover Clustering
Plat form: Windows 2003 enterprise ed,
SQL Server 2000 Failover Clustering SP3A enterprise ed.
Action: How to change the default location for full-text indexing search by
using TSQL/SEM on failover clusterng environment ?
For SQL Server default installation, we have default the locations for the
FTDAT ...
Mon, 3 Jan 2005 10:35:03 -0800
|