Books and material
Tue, 16 May 2006 14:56:34 +1000
Anyone knows where can I find more info on setting up and configuration of
Full-Text searching in EM and Query Analyser?
The reason I ask for material is I used EM and also QA to create catalog and
added tables and columns. But cannot get it work -
item count is 0, it is always idle and the CONTAINS SQL alwa ...
|
Concatenate text with the "text in row" option
15 May 2006 07:15:22 -0700
Does anyone know how to concatenate text to an ntext field when the
"text in row" option is enabled?
...
|
Find out which table columns are included
Mon, 15 May 2006 16:29:07 +1000
I have created a Full-Text Catalog in Pubs include table authors.au_lname
and au_fname in EM.
I scheduled the table and catalog population an hour ago(it showed the Last
Population Date), however, in EM I noticed the status of the catalog is Idle
and the Item count is 0 on the Status tab. And on the Schedules ...
|
full-text indexing problem after upgrade
12 May 2006 06:25:41 -0700
hi there,
we've got a little problem with our indexing catalogs after an upgrade
from sql server 2000 standart to sql server 2005 express.
as we don't need such a big edition like standard we decided to use
just the express edition of sql server 2005.
well in sql 2000 we had some full-text catalogs for ...
|
SQL2005 full text search performance
Thu, 11 May 2006 11:46:58 +0200
Hello all !!
I installed my sps2003/ wss2003 SP2 with sql server 2005.
I did few test of full text search and saw performances are very poor.
i use sql server 2005 x64 SP1 with windows 2003 x64, i did an "optimisation"
of my index file (from enterprise manager) perfomances has been a little bit
improved b ...
|
Edit botton does not work
Wed, 10 May 2006 10:18:02 -0700
Hope someone can answer my question:
On a aspx page, when I click a "Edit" botton and the page does not fresh,
what would be the causes?
The harddrive that hosts the SQL Transaction Log Back Up is 99% full, does
it matter to the functioning of the aspx page??
Thanks,
Frank ...
|
Complex CONTAINS clause
Wed, 10 May 2006 12:46:26 -0400
I'm searching a database of art information and have created a full-text
index on a single table (tblText) that brings together all of the searchable
text fields; the table has about 160,000 rows. The web page for full-text
searching is generalized so that queries of almost any complexity can be
construct ...
|
|
|
SQL Server 2005 - Fulltext over multiply columns
9 May 2006 15:09:44 -0700
hi all,
lets say a user can enter 1 of the following combinations into a search
query:
"starbucks"
"starbucks, San Francisco"
"starbucks, USA"
"starbucks, San Francisco, USA"
"starbucks, San Francisco, California"
"starbucks, San Francisco, California, USA"
my fulltext database has the following col ...
|
FTS 2005 system exception c0000005 every few seconds
9 May 2006 02:29:43 -0700
L.S.
While running a full population on a full-text index the following
message keeps coming almost every second in the Event Log:
Event Type: Error
Event Source: MSFTESQL$SQLEXPRESS
Event Category: MSFTESQL Service
Event ID: 1053
Date: 5/9/2006
Time: 10:44:51 AM
User: N/A
Computer: SVR-PROD1
Des ...
|
FTS 2005 vs index server
8 May 2006 13:58:06 -0700
We are taking a web app that has used index server for the last 3 or 4
years and splitting it. One client will own a version and another
client will retain ownership of their copy. In setting up the new
clients copy, we have been discussing the option of using FTS in sql
2005. We used it in sql7 and it got ...
|
