Questions tagged [full-text-search]

53 questions
1
vote
2 answers

Slow Search since moving from 2003 Server to 2008 R2

I moved a client from a old Windows 2003 server to a new fancy Windows 2008 R2 box. I have been able to get everything to work properly except for the search function inside a program called Invoice 2 Go. Invoice 2 Go searches small text files…
Frank Owen
  • 11
  • 1
1
vote
1 answer

Adding features to an SQL Server 2008 standard with SP1

I have MS SQL Server 2008 with SP1 installed. I want to add the Full text feature to the installation. Do I need to run the SP1 update again after I add this feature? If I do try to run it (SQLServer2008SP1-KB968369-x64-ENU) it fails with this…
poopa
  • 75
  • 1
  • 10
1
vote
3 answers

grep/search for multiple lines in a file

Let's say I have a file with a long nested array, that's formatted like this: array( 'key1' => array( 'val1' => 'val', 'val2' => 'val', 'val3' => 'val', ), 'key2' => array( 'val1' => 'val', 'val2' =>…
GSto
  • 391
  • 1
  • 3
  • 8
1
vote
0 answers

How to create full-text catalog as default catalog?

This would save me the redundant ON MyCatalog phrase when I create full-text indices. For example, CREATE FULLTEXT INDEX ON MyTable ( MyField1, MyField2, MyField3 ) KEY INDEX PK_MyKey ON MyCatalog /* I want MyCatalog to be default, so I…
1
vote
2 answers

How do you find the name of an existing full text catalog in SQL Server 2008 Express?

I have SQL Server 2008 Express installed. Several months ago I created a full text catalog and index. I would like to index some additional table columns now, but I can't remember the name of the existing catalog. How do I find out the name of an…
0
votes
1 answer

How do I configure full-text InnoDb functionality in MariaDB on AWS RDS?

I'm in the process of moving to MariaDB on RDS. My tables are up and running and everything looks good, but given that I'm on MariaDB 10.0.24, I'm considering switching a couple of my MyISAM tables over to Innodb. Prior to this, I required using…
0
votes
1 answer

Searching for files containing text (not string) in bash

How do I find files containing some particular text containing newlines and plenty of other charachters all sorts of quotes and backslashes using terminal?
0
votes
1 answer

How do I modify the thesaurus for full-text-indexing in SQL 2005?

So I've read this: http://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server/ And I've made the following modification to the tsENU.xml file to include the "programmer" and "programming" synonyms:
Steve Wortham
  • 197
  • 1
  • 9
0
votes
2 answers

Search logs for unique email addresses

I want to search my log-files and only show unique email-addresses that is preceeded by "MAIL FORM:" For example if I search maybe I got those hits: Mon 2014-03-17 00:01:38: <-- MAIL FROM: Mon 2014-03-17 00:01:38:…
berocoder
  • 197
  • 2
  • 9
0
votes
1 answer

IIS6 Indexing Service indexing asp.net codebehind (.aspx.cs) files

I've setup a few catalogs on an Windows Server 2003 IIS6 install, each tracking files within a website. In the Properties -> Generation Dialog for each catalog, 'Index files with unknown extensions' is turned OFF. 'Inherit above settings from…
Patrick F
0
votes
2 answers

full-text-search on Win SBS 2008 network drive using Win 7 64-bit client

I got a Win SBS 2008 that servers 10 Client machines. 2 of the 10 client machines are running Win 7 64-bit. The other 8 are running Win XP 32-bit. The Win SBS 2008 has a folder which contains bills that the company has written for its customers. The…
kiltek
  • 143
  • 1
  • 8
0
votes
2 answers

Exchange 2007 ResetSearchIndex.ps1 time

I am relatively new to exchange. We are running Exchange 2007 sp2 for a medium/large institution and we are having trouble with OWA's search function not working. I was going to try running ResetSearchIndex.ps1 but it looks like it needs to be run…
Schuyler
  • 103
  • 5
0
votes
2 answers

High MSSEARCH Wait Type in SQL Server 2005

This week I've run into a problem with the MSSEARCH wait type, and I haven't been able to fully diagnose the problem. The server had been running with no problem for several weeks until the other day, when it suddenly started taking too long for…
ivanmp
  • 180
  • 1
  • 10
0
votes
1 answer

Livelink ECM 9.x. Why Full Text Search Doesn't work for my document

Please explain me how does Full Text Search work in OpenText Livelink ECM? When I add Microsoft Word document to a folder "Full Text Search" doesn't find it though queried word is the only word in a document What I do wrong? Or may be I shall wait…
Andrew Florko
  • 175
  • 1
  • 2
  • 8
0
votes
1 answer

Ideas for doing large-scale full-text search on high-insert MSSQL database

I've got a reasonably large MSSQL database with a table of about 6 million rows and around 50k inserts daily. One of the things I'm starting to struggle with is fulltext search, as I've a requirement for one of the columns in the table to be…
growse
  • 8,020
  • 13
  • 74
  • 115