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 ?
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).