Regarding SQL Queries - TimeOut Problem

From: narayananst (narayananst_at_discussions.microsoft.com)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 05:27:02 -0800

I am doing my search in a 1.3 million records table. I have used FullText
Indexing in that table. I am fetching top 1000 records only, still I am
facing Timeout Expired error in my web application. I am using a DotNet Web
application to do this Search. Is there anything like Indexing Partition in
SQL Server 2000 or any other suggestions to tune my query ?

Relevant Pages

  • Error with Full-Text Indexing Wizard - sql server 2005
    ... I enabled full text indexing on my database and on my table (sql Server ... My table has a unique index. ... and I keep getting the same error and I never get the FullText Index defined. ... The wizard will close because it encountered the following error: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Search using locate taking too long
    ... "fulltext" indexing. ... I went looking for the phdbase and it appears to ... Bernhard Sander ...
    (microsoft.public.fox.programmer.exchange)
Loading