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 ?