Posted by lucm on 12/18/06 14:28

> Right now we need to know
>
> 1. Enterprise Edition has its own Query running mechanism ( which is
> different and faster than Standard Edition mechanism) or NOT ?
> 2. If it is special, what kind of performance differences we will get
> while using Std Edition.
> 3. Is there any specific DB size ( or table sizes ) for which Standard
> Edition is fine and after that one should go for Enterprise.
>
> Thanks in advance
> Nitin Goyal

The engine is not the same. Have a look here:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
especially in "Scalability and Performance" and "High Availability"
sections.

As for choosing Standard or Enterprise, you should think about
concurrent users and operations, not database size.

Regards,
lucm

[Back to original message]