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:
- Is the hardware exactly the same?
- Is the database schema exactly the same?
- Is the data exactly the same?
- 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
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- The Best SQL Web Links
- Have a SQL Server tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical SQL Server questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our SQL Server gurus are waiting to answer your toughest questions.
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.