Just went through this moving a database from SQL 7 on an old machine to SQL 2000 on a new machine with much more memory.  Queries that were instantaneous on...