| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 Full-Text Catalog Rebuild Posted by Owen T. Soroke at 7/21/2003 11:48:07 PM I am trying to create a query which will remotely rebuild an SQL
Full-Text catalog that has been stopped and is otherwise inaccessible
without visiting the server site and rebuilding in Enterprise Manager.
Anyone who can offer me some advice, your help would be greatly
appreciated.
Regards,
...more >>
why unable to use the full text search Posted by Tommy at 7/18/2003 3:24:07 PM I start the full text search service from the SQL Server Service Manager,
but in the enterprise manager, all actions concerns with the full text
search are all unable to choose, what is the problem?
...more >>
single-column index for change tracking Posted by Adnan Selimovic at 7/17/2003 9:21:26 PM Hi folks! I'm enabling FT indexing on 2 tables. On one table it work good
because it has a single column primary key and index. The other table is
problematic one. It has a primary key consisting of three fields and index.
We used incremental method for FT so we have timestamp column in this ta...more >>
FTS in Typo3 Posted by Marc Hoeppner at 7/17/2003 3:32:49 PM Hi,
does anyone know how the quality of the FTS in Typo3 (PHP/MySQL) compares to
SQL's? - I have to do a competitive bid and have few infos on Typo3, but I
already know a lot about SQL's FTS. I also know that Typo3 seems to be
limited to html, txt and doc. PDF seems possible if you use an exte...more >>
Problem with CONTAINS clause and special characters Posted by Hen at 7/17/2003 1:37:10 AM
Hi,
I have a database that I want to search for words
that have special characters inside like a dash or a slash
like "T-SQL" or "T/SQL" with the CONTAINS clause.
I tried CONTAINS(description,'"T-SQL"') and it gives me
the count of rows with "SQL" appearing in the description field whi...more >>
DB Design / Hardware Advice to optimize FTS query performance Posted by robnews NO[at]SPAM iGive.com at 7/16/2003 8:28:28 AM We're implementing FTS on SQL 2K from scratch. I've never done this
before - so please excuse (and highlght) newbie-type mistakes.
Looking for advice on best way to design for the following:
Goals:
Query Speed
Ease of Maintenance
Less Important (I think):
Population time
Situation:
...more >>
Spanish linguistic analysis package missing Posted by Claudio Ledermann at 7/16/2003 8:09:51 AM Hi,
I'm using FTS on a SQL Server 2000 database populated
with spanish text, so I need to enable the spanish options
for noise words and word breaking. All the documentation
says that SQL Server includes the following linguistic
analysis packages:
Chinese_Simplified
Chinese_Traditio...more >>
full text search CPU Posted by kris at 7/15/2003 2:49:37 PM Hi,
Windows 2000/ SQLserver 2000 sp3
i want to put fulltext search for my reports. so i tried
the fulltext search testing on my test server. the
Mssearch is taking 90% Cpu. So i dont want to put the
search service in my production box. I want to move the
data to report server using Tra...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
null Contains clause Posted by Jason at 7/15/2003 9:14:17 AM I'm writing a proc that has an input parameter called
@keyword. The proc will then use this paramter in a
where clause as follows:
WHERE CONTAINS(item_long_description, @keyword)
The problem I am having is when the @keyword parameter is
null, the proc needs to return all records in the ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |