1) Review SQL Server 2000 database which collects approximately 2,000,000 records a week, and recommend/implement ways to improve efficiency.
2) Review two (2) MS VB 6.0/crystal reports programs which store data in the database and retrieve reports. Recommend/implement changes to improve speed of queries, modify as necessary to support changes made in #1, and generally optimize code.
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.
Windows 2000, Windows XP