|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Introduction to Search Posted by Samuel Shulman at 6/29/2006 4:13:08 PM Hi
Since I have never had a good search methods I am looking for some reading
material/source code to know what is achievable relatively easily
Thank you for your suggestions,
Samuel
...more >>
Architecture question Posted by JeremyGrand at 6/29/2006 11:09:04 AM We receive hundreds of faxes per week. The fax machine dumps pdfs into a
folder on our server (other formats are possible). The goal is to identify
the customer and project the fax applies to, extract a small amount of
specific data from the document and add a record to our database, and stor...more >>
Fulltext search results Posted by Maycel Kollau at 6/29/2006 4:24:24 AM
Hi,
is it possible to return detailed information about fulltext searc
results, like linenumbers ?
I'm fairly new to using the fulltext search funtionality. I have bee
playing around with it for a few days now. Does anyone know if this i
possible ?
Thanks,
Mayce
--
Maycel Kolla
----...more >>
Problem with Punctuation under neutral LCID Posted by Michael Schroeder at 6/28/2006 6:49:02 AM Hi out there,
could anyone explain?
System: WinServer 2003 German
SQL Server 2003
SQL query on fulltext field which contains revision no. e.g. 10.02.0512
After setting the LCID to neutral (0) by SQL statement I got better results
than querying unter LCID German (1031). But one problem...more >>
Using wilcards in a fulltext index Posted by kforem NO[at]SPAM hotmail.co.uk at 6/28/2006 12:54:55 AM Hello,
I have a fulltext indexed column which contains some like:
Section 0 Name
Section 1 Name
When I run a query like:
select *
from tbl_FullTextData
where contains(name,'"section 0"')
It returns records, but when I run:
select *
from tbl_Schemenamesearch
where contains(name...more >>
Removing noise words in SQL 2005 Posted by Nick Gilbert at 6/23/2006 5:00:18 PM Hi,
I have the problem that if I search for certain phrases in SQL 2005 such
as "voice over", it returns no results.
I am using the following syntax:
declare @criteria varchar(100)
select @Criteria = N'("voice*") AND ("over*")'
SELECT CategoryID, category, keywords
FROM tblCategory
...more >>
Solution to do Accent Insensitive Full Text Search with SQL Server 2000 Posted by velum at 6/23/2006 11:58:39 AM Making accent insensitive searches with Full Text Search
Installing an accent insensitive version of Microsoft Search
Service
It is really a shame that Microsoft did not provide a free solution for
doing accent insensitive Full Text Searches (FTS) to customers who
purchased SQL Server 2000....more >>
Solution to do Case Insensitive Full Text Search with SQL Server 2000 Posted by velum at 6/23/2006 11:50:32 AM Making accent insensitive searches with Full Text Search
Installing an accent insensitive version of Microsoft Search
Service
It is really a shame that Microsoft did not provide a free solution for
doing
accent insensitive Full Text Searches (FTS) short after the release of
SQL Server 2000. ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
CONTAINS acts weird? Posted by Roel Korsten at 6/21/2006 4:48:57 PM Hi all,
I'm a bit lost in my Full_Text_Search_Adventure:
I've got a PDF-document in a SQL2005 table in which the following line
resides:
.... homer is a computer geek ...
I'm querying the following statement:
SELECT [fieldname]
FROM [table]
WHERE CONTAINS([indexed_fieldn...more >>
FTS for noise chars only Posted by NeilT at 6/19/2006 11:53:17 AM Hi.. SQL 2K issue. My client wishes to FTS for certain noise chars
only, e.g. % which of course isn't in the noise word files. The best
I've been able to come up with to resolve this is to escape the
characters when I enter the string into CONTAINSTABLE, however the
results return as if the quer...more >>
dotLucene and microsoft sql 2000 Posted by Christian H at 6/19/2006 12:00:00 AM Hello,
We're looking into the option of using dotLucene/seekafile server to do the
fulltext searching on a sql2000 database, but haven't really seen dotLucene
used directly with sql2000.
Does anyone know if it is possible to use Lucene/Seekafile server directly
with files stored in the dat...more >>
accent sensitive *and* insensitive Posted by lisa NO[at]SPAM starways.net at 6/14/2006 2:25:44 PM Forgive me if this has already been asked, but I need to be able to
search either with accent sensitivity *or* insensitivity, depending on
user settings or locale.
Is there any way to set up my indexing (either in 2000 or 2005) so that
I can choose during the search itself whether or not to be...more >>
HOWTO: Get word counts from Full text indexer Posted by Kevin English at 6/14/2006 1:38:51 PM What is the query syntax when querying the full text indexer to obtain the
list of words indexed and their corresponding counts?
...more >>
Order of full-text indexing Posted by almurph NO[at]SPAM altavista.com at 6/14/2006 7:46:12 AM Hi,
Should I build a full-text index on a field before or after I create a
non-clustered index on that field. Or does it matter?
Al.
...more >>
FTS and deadlocks Posted by Alex Sibilev at 6/9/2006 6:27:01 PM
Hello,
I'm trying to figure out how to eliminate deadlocks in the system. It looks
like one process
involved in deadlock is process that populates FT index. The second process
- is replication procedure
that updates that ft-indexed table (tab1).
At the moment FT is setup with change t...more >>
CONTAINSTABLE fails on AND NOT Posted by TonyWeb at 6/7/2006 11:56:05 AM Hi,
I've seen this addressed with regards to CONTAINS searches, and the kludgy
work-around of using a seperate CONTAINS statement for each NOT condition.
However, I have not seen this addressed using the CONTAINSTABLE query. My
fear is that it will require a similar kludge, requiring eith...more >>
Full-Text indexing wizard Posted by Alan at 6/5/2006 12:00:00 AM How to include more than 1 table in the full-text indexing catalog in EM
using Tools -> Full-Text Indexing wizard ?
...more >>
Indexing driver Posted by Alan at 6/5/2006 12:00:00 AM MSIDXS driver is by default installed in Windows or do I need to download
from MS site ?
...more >>
BLOB field search Posted by Alan at 6/2/2006 12:00:00 AM Hi,
I would like to store some document like doc, pdf in a blob field, do I need
any other field to aid the FTS on this field like an extra field to indicate
the type of the document ?
Or do I just include this BLOB field in the full index table ?
...more >>
Start full - table and catalog Posted by Alan at 6/2/2006 12:00:00 AM What is the differences between:
EXEC sp_fulltext_catalog 'Cat1', 'start_full'
EXEC sp_fulltext_table 'Table1','start_full'
if "Table1" is a full-text indexed in catalog "Cat1".
Do I need to execute both SP?
...more >>
How to schedule a incremental population Posted by Alan at 6/2/2006 12:00:00 AM What SP can be used to schedule an incremental population ?
...more >>
Store documents in image/text/varbinary column Posted by Alan at 6/2/2006 12:00:00 AM I don't understand how to store the documents like pdf, rtf in these
columns? Don't they stored as BLOB ?
...more >>
Windows 2000 Professional Posted by Alan at 6/1/2006 4:03:13 PM Can Full-Text searching be running on Win2K Professional ?
...more >>
User account Posted by Alan at 6/1/2006 3:59:38 PM This is from the web:
>>>
5. If a full-text catalog population or query fails, check that there is no
mismatch of user account information between the MSSQLServer and MSSearch
services.
Change the password for the MSSQLServer service using the SQL Server
Enterprise Manager (do not use Ser...more >>
MSSearch process uses only 1 CPU Posted by Angelo Brusati at 6/1/2006 3:16:49 PM I've a 4 CPU server with Windows 2003 as OS and SQL 2000, SP3a and it
performs very good.
The SQL in configured to use AWE memory - 5 GByte - and to use all available
CPUs on the machine.
Moreover the MSSEARCH is configured to use at least 1 GByte RAM
(CacheSizeMin and Max), according to a...more >>
Logon account privileges Posted by Alan at 6/1/2006 3:05:29 PM These are getting from Full-Text Search Publisher.doc downloaded from MS
website,
>> Verify that the account used by SQL Server has the following permissions:
Log On Locally
Log On as a Batch
Access this computer from the Network
Log on as service
...more >>
Does Windows XP support full-text searching Posted by Alan at 6/1/2006 2:43:17 PM Can Microsoft Search service installed on Windows XP professional with no SP
?
...more >>
How to enable an account to do a full-text search Posted by Alan at 6/1/2006 12:11:30 PM I have a windows user account in SQL Server 2000 would like to use it to
start MSSQLServer service and create a catalog in EM.
But the status is always idle after several attempts of full population, how
do I make it work?
...more >>
Gatherer log Posted by Alan at 6/1/2006 12:05:26 PM This is from the gatherer log after I started a full population:
- The gatherer has started
- The initialization has completed
- Started Full crawl
- MSSAL75://SQLServer/75d7831f Add Error fetching URL, (800700e9 - No
process is on the other end of the pipe)
- Completed Full crawl
Any idea ...more >>
FTI and a non-clustered index...? Posted by almurph NO[at]SPAM altavista.com at 6/1/2006 8:33:46 AM Hi everyone,
Hope that you can help me wit this one. Can a particular field in a DB
have a full-text index on it and a non-clustered index?
Any comments/suggestions/user-experiences much appreciated.
Al.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |