MS-SQL Server 2000 database containing about 1,5 -2 million records. It is indexed using Full-Text and my main table (nearly all records) also has a timestamp column to speed up incremental population. Simple SELECT....CONTAINS() queries take way too long to process. About 2 minutes. I need a KNOWLEDGEABLE person to speed up my database and my queries. Just to clear things up, my queries are already in stored procedures and I have indexes also. However, I suspect my indexes are in fault here. The server is a P3 650 with 384 megs of ram. Please send along your SQL 2000 skills and experience. Thank you!
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.