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 ?
Asked
Active
Viewed 169 times
1 Answers
1
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).
TomTom
- 51,649
- 7
- 54
- 136
-
can you explain detailed. i really want to hear thank you. or you can give me a link which explains well. – Furkan Gözükara Dec 30 '10 at 15:36
-
a link? http://www.microsoft.com/SqlServer. 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. – Furkan Gözükara 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 07:39