Home / server / Questions / 217387
Accepted
MonsterMMORPG
Asked: 2010-12-31 05:04:04 +0800 CST

Are there any performance difference between Microsoft SQL server 2008 Editions

  • 772

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 ?

windows sql-server performance diff

1 Answers

  1. Best Answer

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

    • 1