| 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 is installed, search service running, but not enabled in Enterprise Manager? Posted by Marvin Slayton at 9/14/2003 9:47:27 AM SELECT @@Version results:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
I had to install Microsoft Search from my CD and now I have Microsoft Search
run...more >>
FREETEXT Question Posted by Bill at 9/12/2003 2:00:55 PM Will FREETEXT search using booleans, or will it only do an OR on searches? I
need to search across two database columns, so I can't use CONTAINS.
ba
...more >>
Populating speed decreases progressively Posted by Naser geraminia at 9/12/2003 12:38:48 PM Thank you john
My database and FT Catalogs are positioned in seprate hard
disks(in 2 hard drives), but i have no information about
what aredifferent disc controller and channels are.
Indeed, in starting full population i have a very high
rate(15000 rows at first minute), but next the ra...more >>
Noise Word Filtering Posted by Chanakya Konakandla at 9/12/2003 5:03:37 AM When my query has noise words and If I try to use CONTAINS
clause, I get error like this "Execution of a full-text
operation failed. A clause of the query contained only
ignored words."
Say for eg: my search string is 'a smart card solution' and
I want to use all of these words for search...more >>
FTI - Full population Posted by Naser geraminia at 9/11/2003 9:07:16 PM Hi all.
I have an keywords table by 2000000 rows that contains an
int(4) key and a varchar(50)
Keyword(Unique index) in Sql Server 2000. I need very fast
searching this table and so I Used Full-text Service.
the problem is: After about 80 seconds of starting full
population, speed of ad...more >>
Compressed documents? Posted by Brandon Lilly at 9/11/2003 2:45:18 PM Currently, we have documents stored in the database the normal way,
and all is good with the world of fts. However, we have some clients
that have a LOT of documents, most of which are stored and never
viewed again, that take up an enormous amount of diskspace.
We were considering compressing...more >>
FTI - Full population Posted by mitra fatolahi at 9/11/2003 2:17:55 PM Hi All,
Can a Full population be stopped in the middle of the
process and then later resume from where we had stopped
the process?
Thank you,
-Mitra...more >>
Full-text lookup failing with "unknown result" Posted by Fred Forsyth at 9/11/2003 8:47:30 AM I've got a VB app calling a SQL query that has a CONTAINS clause to search a
full-text indexed field. The ADO call is failing with the following error
(code 7607):
[Microsoft][ODBC SQL Server Driver][SQL Server]Search on full-text catalog
'Deals' for database ID 8, table ID 309576141 with sear...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Noise words Posted by SelvaB NO[at]SPAM icode.com at 9/11/2003 6:25:51 AM
How to get noise words from an SP..?
Regards,
Selva Balaji B.
--
Posted via http://dbforums.com...more >>
Quering a Query Posted by Mike NO[at]SPAM MONY at 9/10/2003 7:40:02 AM Hello all thank you for taking the time to read my question.
I am new to writing SQL statements actually I've taken "Querying MS SQL
server 2K with Transact- SQL".. so basically SQL 101.
I need some guidance on how to query a query.
I have a desktop database which contains information on a...more >>
Doubt declare SQLServer Posted by kadu.gertners at 9/9/2003 5:25:21 PM
I'd like to know, if there is a possibility reference declare SQLServer
dynamically?
For example, I've tried execute this query(under), but I received this
message (Server: Msg 137, Level 15, State 1, Line 6
Must declare the variable '@t1'.):
declare @Frase varchar(50)
set @Frase = 'declare...more >>
WildCard in FreeText Posted by Abhijeet Raje at 9/9/2003 5:23:29 PM Hi All,
I want to put wild card in freetext search.
How can I put?
My requirement is if I search for "Memory" it gives me 100 records. If I
search for "Mem" It should give me 100+ records.
Regards
Abhijeet
...more >>
new Noise words that don't exist!? how do i know what to parse out? Posted by Henry at 9/9/2003 4:58:35 PM hello, i have a searchpage that parses out the default US English noise
words. i then perform an inflectional search of each word within the
containstable predicate.
when i search for "new used" , the searchPage runs this query:
SELECT a.category_id, a.categoryName
FROM category a INNER JOIN...more >>
FTS Optimisation question Posted by Tester at 9/8/2003 1:19:43 PM hiya,
I need some help trying to identify a couple of things. The first is
my company wishes to implement searching, its a dynamic website using SQL
server 2000. I have enabled FTS on a couple of tables. I was thinking, SQL
FTS has a filter which I have set to "neutral" also I use the ge...more >>
Word order dependent search Posted by fts at 9/8/2003 6:02:58 AM We need to have a functionality whereby we can have
Word order dependent search - All words entered appear in
the term in the order entered.
Can we accomplish this using FTS?
Thanks...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |