Problem solve Get help with specific problems with your technologies, process and projects.

Query processing speed differences for SQL 6.5, 7.0 and 2000

What is the difference in processing speed between running a query in Query Analyzer for SQL6.5 vs. 7.0 or 2000?

That is not a fair question. How would you answer what is the difference in speed between a baseball, cheetah, and rock? It all depends upon your frame of reference. It depends upon the following factors:

  1. Is the hardware exactly the same?
  2. Is the database schema exactly the same?
  3. Is the data exactly the same?
  4. Is it running in isolation, or are other users accessing the database?

In general, 2000 will run faster than 7.0 which will run faster than 6.5. How much? Depends upon the exact query running against your database with your data and on your hardware. No one else can tell you how much faster it is, because every environment, database, and query is different.


For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.