Regarding SQL Queries - TimeOut Problem
From: narayananst (narayananst_at_discussions.microsoft.com)
Date: 01/03/05
- Next message: pjscott: "Parameter Query"
- Previous message: MichaelK: "Re: #Temp table question"
- Messages sorted by: [ date ] [ thread ]
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 ?
- Next message: pjscott: "Parameter Query"
- Previous message: MichaelK: "Re: #Temp table question"
- Messages sorted by: [ date ] [ thread ]