Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I always wonders this. For example you are using Microsoft SQL server 2008 web edition. It supports your hardware fully. And you upgraded it to Datacenter edition. would there be any performance difference at select,update,insert and delete queries between these 2 editions on same hardware ?

share|improve this question
up vote 1 down vote accepted

Depends what you do. There are some feature differnces (like page / row level compression), which can result in different performacne when used. THen there is the issue in maintenance - online index rebuild (without dropping FIRST).

share|improve this answer
can you explain detailed. i really want to hear thank you. or you can give me a link which explains well. – MonsterMMORPG Dec 30 '10 at 15:36
a link? Go to the differences between editions. – TomTom Dec 30 '10 at 16:16
TomTom that does not explain me anything. Those edition differences. instead of features i wonder performance criteria. – MonsterMMORPG Dec 30 '10 at 19:04
Well, then seriously get the experience yourself. If you are not willing to read the sections of the site- I am not willing to help you. – TomTom Dec 31 '10 at 7:39

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.