|
Need help with full-text performance for large database
We are having significant performance problems with full-text indexing on one
column of a large database.
System configuration:
Windows 2000 Advanced Server with all service packs as of 6/10/04.
We are using SQL 7 with all ...
Sat, 12 Jun 2004 16:19:11 GMT
|
Key column information is insufficient of incorrect....
I am trying to delete all records from a table and could
delete all but two of them. I noticed the two records
have identical info. I am getting the following message:
Key Column information is insufficient of incorrect. Too
many rows were affected by update.
Please help ...
Fri, 11 Jun 2004 13:23:35 -0700
|
Problem with Japanese Inflectional search
Hi,
We have Full Text enabled for five languages, four of them
are latin based and the other in Japanese.
We have built catalogs by specifying the respective
languages for word breakers.
Now the inflectional search is working fine for the latin
based languages but not working for Japanese.
Can anyone ...
Thu, 10 Jun 2004 23:39:07 -0700
|
Ranking problem w/FreeTextTable
We are having problems with the ranking of search results being incorrect. The index is built on 1.6 million rows.
An example of the issue is the user searches for three words 'cowboys hat dallas'. Searching for 'Cowboys' alone brings back 21 results, 'Dallas' alone 460 results and 'hat' alone 1338 results. ...
Wed, 9 Jun 2004 21:47:01 -0700
|
Two databases same structure
All -
I have multiple databases with identical schemas on one Server. I
want to be able to use FTS on each one independently. For example:
DB1 - Table is PersonalInfo, Columns are FirstName and LastName
DB2 - Table is PersonalInfo, Columns are FirstName and LastName
This is the query I want to run on ...
9 Jun 2004 11:24:21 -0700
|
Inflectional and/or not returning the correct results
When doing the following search (SearchAllProducts, keyword, 'FORMSOF (INFLECTIONAL, pens) and FORMSOF (INFLECTIONAL, pads)'), we get 170 records returned. But if we switch the and and replace it with an OR we get 1294 records returned. Whats the part we don't understand is that the OR is not pulling back any of ...
Tue, 8 Jun 2004 13:21:03 -0700
|
Inflectional with and/or results
When I use the following (SearchAllProducts, keyword, 'FORMSOF (INFLECTIONAL, pens) and FORMSOF (INFLECTIONAL, pads)') I get the 170 records I should. But I if change that and to an OR I get 1294 records, but if i split the search into 2, I get pens=748 records and pads=716 records. I would think that the OR shou ...
Tue, 8 Jun 2004 13:06:05 -0700
|
How to determine if SQL 7 SP4 or higher is installed using Registry
You can SELECT serverproperty('ProductLevel').
>-----Original Message-----
>I am developing an .msi package that requires SQL 7 SP4
or higher to be installed. I would like to use the
registry to confirm a valid SQL installation and from
there I can determine if my .msi installation should
continue as n ...
Mon, 7 Jun 2004 09:27:24 -0700
|
How to determine if SQL 7 SP4 or higher is installed using Registry
I am developing an .msi package that requires SQL 7 SP4 or higher to be installed. I would like to use the registry to confirm a valid SQL installation and from there I can determine if my .msi installation should continue as normal or display an error message asking to install SQL first.
---
I couldn't find muc ...
Mon, 7 Jun 2004 08:01:09 -0700
|
Error when starting Incremental Population
Hi all
I have a very large FT catalog on a table.
I have tried to initiate an incremental population
Exec sp_fulltext_catalog 'FT_PATCLAIMS','start_incremental'
and I got the following error :
"Execution of a full-text operation failed. The Gatherer
is shutting down."
I have found no reference to thi ...
Mon, 7 Jun 2004 06:09:45 -0700
|
indexing document stored in IMAGE fields
Hi guys,
in the Full Text Retrieval documentation of MS SQLserver 2000 it's said that the document stored in IMAGE
fields are "filtered" using the Microsoft provided filters (for these file extensions: .doc, .xls, .ppt, .txt
and .htm) or third party filters (e.g. Adobe for .pdf).
Little after there's a note stati ...
Mon, 7 Jun 2004 03:36:05 -0700
|
Determine when Record has been indexed
I am trying to determine when SQL has indexed a text field=2E My=
table has a Text field, a primary key , and a timestamp=2E
I have already executed
EXEC sp_tableoption 'ULARL', 'text in row', 'ON'
EXEC sp_fulltext_table ULARL, 'Start_change_tracking'
EXEC sp_fulltext_table ULARL, 'Start_background_update ...
Sat, 05 Jun 2004 11:19:52 -0700
|
Restoring DB with fulltext index to another server: index recreation steps?
When a database with fulltext indexes is restored to a different
server, what are the appropriate steps to take, and in what order,
to recreate the indexes on the new machine if it has a different
directory structure than the original server? Should the indexes
be removed and then recreated? Any problem rem ...
Sat, 5 Jun 2004 10:53:43 -0400
|
testing - do not reply
"Oz" wrote in message
news:u%23MU3YrNEHA.3744@TK2MSFTNGP11.phx.gbl...
> Identical error on pubs database John.
>
> Thanks
> "John Kane" wrote in message
> news:uBU3C6pNEHA.1340@TK2MSFTNGP12.phx.gbl...
> > You're welcome, Oz,
> > When you said "It's just occur ...
Tue, 1 Jun 2004 11:57:57 +0930
|
Doing a CONTAINS search on multiple tables and columns combined.
I want to do a CONTAINS search on several columns combined.
This example searches each column separately, so that a record is not
included that has one of the search terms in the Desired Position and the
other two search terms in a section body.
SET @SearchPhrase = 'Engineer AND SQL AND VB'
SELECT DISTI ...
Fri, 28 May 2004 21:27:34 -0600
|