We are using Sql Server 2k and a VB 6 application.
I find some of the SQL queries take about a minute to retrieve a single record. But then if I try to retrieve the same record a second time it loads pretty quickly in 5 seconds.
What are some of the ways to optimize SQL performance? Would upgrading to newer SQL versions significantly improve performance?