|
|
|
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 |
Excessive page fault rate by Msftesql Posted by Phil at 9/28/2007 3:59:19 PM We are having excessively high page fault rates by msftesql. Our database
has about 50 million records, and we are performing full text searches about
once every other second.
We are running on a dual CPU server with 8 GB of RAM and a 4-disk RAID 0
array. The OS is Windows 2003 Server Enterp...more >>
CONTAINS not returning anything Posted by NonSequitur at 9/27/2007 5:58:55 PM What am I missing?
The following query fails to return anything:
SELECT * FROM Problems P
WHERE P.start_date > '2006-9-27 0:0:0'
AND CONTAINS(P.Title, '"Install"')
The table's Title column definitely contains "Install" -without the last
AND-clause, the query works fine, and returns many ...more >>
More PDF IFilter problems Posted by LiveCycle at 9/27/2007 1:56:00 PM Hi all,
I'm having some frustrating issues with the PDF IFilter and making it work.
I've read the other posts here, and still haven't been able to figure this
out. I am running SQL Server 2005 Standard 32 bit edition on Windows Server
2003 Standard Edition. I performed the following:
1...more >>
Full-Text Search Posted by Curtis at 9/24/2007 5:52:01 PM I have been trying to figure out how to do a search against my full-text
index where a user enters more than one word.
I can get results back if I just do a search for the name Bob but I can't
figure out how to get reuslts back if I enter Bob Smith.
I have tried the various different query o...more >>
accent-insensitive full text searching for modern spanish Posted by Albatross Singh at 9/24/2007 6:44:03 AM Hi
I believe that SQL 2000 full text is accent sensitive by default for full
text indexing. Can anyone confirm this?
Also. is there any work-around?
What I want to do is seach for "cancer" and return everything that has
"cancer" and "cáncer".
Thanks for any pointers....more >>
full-text catalog incomplete population Posted by BMG at 9/22/2007 9:23:25 AM Hi, we're having a problem with a full-text index not picking up new
rows that have been added since a recent DB server upgrade.
We migrated our database from SQL Server 2000 to 2005 last week (and
to a new machine as well). I copied over the tables, recreated the
index, and everything was wo...more >>
ask FTS index how often a key is stored in the index? Posted by tbh at 9/21/2007 6:40:00 PM hi, i've noticed that in our SQL 2000 systems fulltext search performance
suffers when one searches for a term that occurs frequently in the index.
(of course i realize that ultimately there is no way around this, but I have
some ideas i'd like to explore.)
in my system an extremely rough r...more >>
First FTS-query to slow Posted by Franky at 9/19/2007 2:40:01 AM We are using FTS on a table which has for the moment 4500 rows.
When we restart the FTS-service, or no one uses the search for a while, then
the first FTS-query takes up to 60 seconds. (also when there is only 1 record
returned)
While lookalike queries after the first take about 60 miliseconds...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Integration of Lucene.Net and SQL Server 2005? Posted by DC at 9/11/2007 12:00:00 AM Hi,
I am looking for an alternative to the SQL Server Fulltext Engine
since it is just not fast enough and does not offer the sorting I
require. Also, my customer wants a "did you mean google" when "gogle"
was entered feature. From what I have seen all that is possible with
Lucene.Net.
I a...more >>
Capacity planning and performance tuning - SQL 2005 Full text inde Posted by David Reabow at 9/10/2007 4:06:02 AM I’ve been searching for information on how Full text indexing uses hardware
resources (Memory, IO, CPU etc) and how I can plan for scaling up data
volumes and search numbers. I have found that there is more information
regarding improving the actual indexing process but this is a minor aspec...more >>
Full-text search content Posted by alain NO[at]SPAM infoproasf.com at 9/9/2007 9:48:02 PM Hi All Full-text search experts,
I have an SQL Server 200 Database running with full-text search
enabled and fully operationnal.
I am looking to get the Full-text catalog content to know what are the
most popular series of word in the full-text enabled fields.
Ex : If my full-text field has 4...more >>
Space Required to store a file in database Posted by apondu at 9/9/2007 11:49:39 AM hi,
I had a query on sql database, we know we usually store files of
different type in sql database and its helpful for searching and
retrieving the documents from the database, but one query i had was
related to the amount of space required to store the files in the
database. For Eg....more >>
Apostrophes in Full Text Search Posted by Ramesh at 9/7/2007 12:23:22 PM I would like to search the words like O'Donnel, O'Connor,Steve's etc.. in the attachments. Tried to use ContainsTable and replaced the apostrophe with another before sending to the search engine.
Also i have to search Connor in O'connor
Any thoughts?
From http://www.developmentnow.com/g/104_2...more >>
Turning off signature verification on word breakers Posted by InstantKiwi at 9/6/2007 10:23:01 PM Howdy folks,
Some of you may have experience the issue described in the following
MS kb article, "You may experience a 45-second delay when you run a
full-text query in an instance of SQL Server 2005 that is running on a
server without Internet access" (http://support.microsoft.com/kb/
915850...more >>
Search and Index Question Posted by ChuSoft at 9/6/2007 2:14:44 PM We need to index and search on "(specific text here)".
How can we do a free text search using the above.
...more >>
Get the FTS index keywords list Posted by carignankg NO[at]SPAM gmail.com at 9/5/2007 2:20:18 PM Is there a way to get the Index keywords list?
here is what i need to do
Our database contains a relative small amount of documents so we need
an application that shows ListBox of keywords sorted by index
frequency. The user selected on or many keywords from the ListBox
then launch the sea...more >>
double space handling Posted by Sudhir at 9/4/2007 5:22:03 AM HI,
I am having a problem with double space handler.
i'm taking user input to search for any description, but the problem is that
when user enters search criterion with double spaces in that. for eg 'rock
music' is ok, but if user enters for 'rock music' that means double spacing
betwe...more >>
FTS Weighted Values Implementation Problem Posted by Organic Man at 9/1/2007 9:54:34 AM I don't know if this is an appropriate problem for this forum but will
pose it and if anyone can help, I would be very grateful.
I can run this weighted values FTS in Management Studio on a SQL
Server 2005 db:
SELECT FT_TBL.FullDocNo, FT_TBL.DocType, KEY_TBL.RANK
FROM FullDocuments AS FT_TB...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |