|
|
|
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 |
CONTAINS vs. CONTAINSTABLE performance Posted by Kerry at 4/30/2007 11:40:08 AM We are implementing an FTS to support google-like drop down boxes.
When I originally constructed my query using a "Contains" parameter,
performance was in the neighborhood of 4 seconds. However, when we
implemented CONTAINSQUERY, performance was on-par with our
expectations (far less than a sec...more >>
FTS Dutch operating system Posted by ScottTaylor-PAS at 4/30/2007 9:34:02 AM I am getting an error running a full-text search against a database created
on a dutch operating system. The same query on the english-created database
does not produce an error.
System.Data.SqlClient.SqlException: Search on full-text catalog
'ImageCatalog003' for database ID 6, table or i...more >>
Full Text Catalog Not Building Posted by ibaldwinjr NO[at]SPAM gmail.com at 4/30/2007 5:39:27 AM Hi,
We have created a catalog for our search engine in our website and
everything was working fine before. Right after we created a new
stored procedure that updates the table in which the catalog was
referencing to, our search engine stopped working. We have created the
catalog multiple time...more >>
setting up full-text catalog Posted by shank at 4/30/2007 12:00:00 AM 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 2)
I need help on setting up Full-Text searching. I've got 2 tables: MMOAlbums
(700 rows) & MMOTitles (1000 rows...more >>
Pending Changes stuck Posted by Kyle Jedrusiak at 4/25/2007 12:00:00 AM It seems like Track Changes Automatically is working, but the changes aren't
getting pushed into the index.
I had to turn it off and back on and force and update.
Am I missing something?
It's happening on a number of indexed views.
...more >>
FT query plan Posted by mEmENT0m0RI at 4/24/2007 11:41:10 AM The following query:
SELECT PatientGUID
FROM PATIENT_SEARCH PS
WHERE PS.LicenseID = '465f20fc-8bd5-4802-a3f5-2a5f702be128'
AND CONTAINS (PS.SEARCHCOL , ' "patient*" ')
Shows 2500 rows qualified by LicenseID =
'465f20fc-8bd5-4802-a3f5-2a5f702be128', but 5000000 rows for "Remote
Scan". Tak...more >>
contains query Posted by coffej at 4/24/2007 11:23:46 AM I have been trying to get the following to work:
(select p.uid, p.title, (DATENAME(MONTH,p.newDate) + ' ' +
DATENAME(DAY,p.newDate) + ', ' + DATENAME(YEAR, p.newDate) ) as Date,
p.tableName from authorsPubs AP, publications p, authors a where
AP.pubID = p.uid and AP.authorID = a.author_ID and ...more >>
Sql 2005 Full-Text Web Searches with levenshtein and double metaphone Posted by Ben Fidge at 4/24/2007 12:00:00 AM Hi,
Is it possible to incorporate levenshtein edit distance and double-metaphone
matching into Sql Server 2005's Full-Text Search queries using FREETEXTTABLE
or CONTAINSTABLE?
I'm working on a web-site that allows user to search multiple tables, and i
want the ability to pull back rows w...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Multiple columns full text search doesn't seems to work properly Posted by Xavi at 4/23/2007 4:14:31 AM Hi all !
I have a full text search index on a table with several fields
indexed.
I tried the following query :
SELECT MyIndexedTable.MyIndexedTableID
MyIndexedTable.Title,
KEY_TBL.RANK RANK_Total
FROM
MyIndexedTable
INNER JOIN
CONTAINSTABLE(MyIndexedTable,*,'"sport" AND "news"')...more >>
Full text index removal Posted by iiman at 4/23/2007 12:00:00 AM RESTORE FILELISTONLY
FROM DISK = 'C:\Full0100.BAK'
Here is the result
database d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\database
..mdf
database _Log d:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\database _log.ldf
sysft_PhraseologyIndex d:\Program Files\Microsoft...more >>
Highlight words from search expression Posted by Lior Shorshi at 4/22/2007 4:42:41 AM Hi,
I want to create a search engine which will display a short text
description in the surrounding of the searched words. The problem is I
can't find the exact words in my search phrase in the results because
of stemming. Is there any way I can which words in the results were
responsible fin...more >>
thesaurus list Posted by dragooon at 4/19/2007 10:35:59 PM Is there anywhere to download a fully-populated thesaurus list for SQL 2000
or SQL 2005 full-text search purpose? The SQL online book mentioned that
"You will find a list of thesaurus files located in the
SQL_Server_install_path\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATA\
directory. You will...more >>
.doc iFilter not working for Mobile docs Posted by Jeff at 4/19/2007 2:24:04 AM Hi,
I have implemented full text searching over files stored in a varbinary(max)
field and this works great :)
The only issue i am now having is that users creating office documents
created on a Windows Mobile device such as word docs are not being searched.
The extension is .doc but th...more >>
Can't put duplicate words in different expansion sets? Posted by spencer at 4/18/2007 10:08:41 PM Can't you have duplicate words with different meanings in different
expansion sets? Is this a bug?
Please try this repro below. It uses a thesaurus with 2 expansion sets.
Each set contains the word kind. The sets are like this:
1. kind, sort, class
2. kind, caring, considerate
When I ...more >>
Fulltext Catalogs in SQL 2005 Express Posted by GitarJake at 4/18/2007 9:07:45 PM Hello,
SQL Server Express 2005 with the Management Studio.
In SQL 2000, you can right click fulltext catalogs and select a "Rebuild"
option.
I can't find where to do this in the Management Studio. I don't even see a
"Storage" section.
How do you manage Fulltext Catalogs in 2005 Expr...more >>
RESTORE DATABASE is terminating abnormally Posted by GitarJake at 4/18/2007 8:47:40 PM Hello,
I am getting the rather odd error below; hope you can help.
RESTORE DATABASE is terminating abnormally. File 'C:\Program Files\Microsoft
SQL Server\MSSQL.1\MSSQL\Data\trial_44testingc' is claimed by
'sysft_KB_SearchAssetsCatalog'(65540) and 'sysft_KB_SearchCatalog'(65537).
The WIT...more >>
Noise File. Posted by AF at 4/16/2007 12:41:27 PM After changing a noise file - does the FTS have to be restarted?
Also, any way to determine which noise.eng file is being used? There
are several locations...
...more >>
ISABOUT deprecation? Posted by spencer at 4/14/2007 4:57:26 PM Is is possible that the ISABOUT term of the CONTAINS predicate could be
deprecated in SQL Server? This concern came up when I read about its
deprecation in Windows SharePoint Services documentation:
Important:
While this feature is still supported in the current product version, it may
be...more >>
Backing up Database Posted by Gabe Matteson\\ at 4/13/2007 12:36:08 PM When I try to backup a SQL 2000 database I recieve the following error in
the output log. Any ideas? Thank you.
SQL 2000 w/ SP4
[39] Database SolRounder: Database Backup...
Destination: [G:\Backups\SolRounder\SolRounder_db_200704131221.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Erro...more >>
full-text search failed with one million of key words (Sqlserver20 Posted by Europa_Lili at 4/13/2007 7:30:03 AM Hello,
I have to make big tests with sql server 2005 express (i'm waiting credits
to buy a full license).
I detected a big problem with my full-text search, and i don't know if it's
a bad use of Sql Server or if it's impossible to do it!
Here's my use case :
a table like this :
p...more >>
Full text memory usage Posted by Tom at 4/12/2007 10:44:32 PM Hi
I work with SQL 2005 and I know how it uses RAM but I know just some basic
stuff about Full-text catalogs and since we plan to implement them in the
future I need to know a few things.
1. Can you set min and max memory for full text service like it can be set
for SQL service?
2. Does...more >>
Browsing content of a FullText catalog Posted by vsld NO[at]SPAM free.fr at 4/12/2007 5:40:21 AM Good afternoon,
I'm looking for a way to browse or dump the content of a SQL Server
2005 FullText catalog. I saw that cidump.exe used to be the reference
in this matter but I haven't been able to find any tool which is
working with the current version of SQL Server (2005 SP2). Do I miss
any D...more >>
Searching with AND - the Google way Posted by Rune Leknes at 4/12/2007 12:00:00 AM I would like to be able to search my table for records containing several
words.
Like a standard Google-search where AND is implied when you enter more than
one word.
Example:
My PRODUCTS table has a free-text index on the columns [Title] and
[Description]
Row1: Title: "MS Word", Descrip...more >>
SQL server 2005 fulltext index Posted by madhu at 4/11/2007 6:27:22 AM I have firstname, lastname, MRNo, date of birth (varchar) as index columns in FTS. I need to be able to search these columns by order
Ex:
SELECT [oid]
,[FirstName]
,lastname
,[MNo]
FROM tblNames
where contains(firstname, ' "test*" ')
or contains(lastname, ' "pr*" ')
...more >>
Full text index population is slow Posted by innocenzo.daraio NO[at]SPAM gmail.com at 4/10/2007 11:46:26 PM I have 1 milion rows on a SQL server 2005 SP1 with 2 Text columns to
be indexed.
The DB is replicated on another server. Transactional.
On the Publisher the population take the CPU near the 100% for 3 day
and then the work is done.
On the subscriber, that is also the distributor the work don't ...more >>
Execution of a full-text operation failed. A clause of the query contained only ignored words. Posted by John at 4/9/2007 12:26:41 PM I have two Windows 2003 servers with SQL Server 2000 at 8.00.2039 on
both servers. One returns rows and the other gets error "Execution of
a full-text operation failed. A clause of the query contained only
ignored words." for this query.
SELECT TOP 10 U.t_url, U.t_title, U.u_url_id, MAX(FTT_A....more >>
Filter for WordML vs Filter for XML vs Filter for Text Posted by Brian at 4/3/2007 3:26:43 PM We currently are saving WordML (Word 2003's XML format rather than binary
format) docs into a column of our SQL Server 2005 database and full text
indexing on it. Works okay, but not great. For example, all the XML tags
are indexed... so you find many words that are not in the document (from...more >>
Contains finding rows that don't have search word Posted by Andy in S. Jersey at 4/2/2007 8:32:03 AM I am using contains to search a varchar(max) field.
select Page_Id from Q_Page
where contains (Text, 'webapp_user_adduser')
My problem is that the Page_Ids that are being returned don't have the text
I am searching for in them. I get back almost every row. I should only get
back 3 or 4....more >>
Problems with long execution time Posted by karl_a at 4/2/2007 2:04:03 AM Hello,
We have recently released a new version of our gallery function where we
give the users the possibility to upload images, videos and sound files. We
moved about 15 million objects from the earlier version of the application.
Each day about 150- to 200 thousand objects are uploaded an...more >>
Can't get AND to work. Posted by Mufasa at 4/1/2007 12:00:00 AM I have a contains string that says ' "Log In" ' which works fine and returns
results. I put in ' "Log" or "In" ' and I get results. I put in ' "Log" and
"In" ' and get "Informational: The full-text search condition contained
noise word(s)."
Any thoughts?
What I want to do is be able to h...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |