Posted by lucm on 12/15/06 16:20

Nishant Saini wrote:
> Dear All,
>
> We have a database which contains many tables which have millions of
> records. When We attach the database with MS SQL Server 2005 Standard
> Edition Server and run some queries (having joins, filters etc.) then
> they take very long time to execute while when We execute same queries
> on Enterprise Edition then they run 10 times faster than on standard
> edition.
>
> Our database does not use any features which are present in Enterprise
> Edition and not present in Standard Edition. We want to know what are
> the differences between Standard Edition and Enterprise Edition for
> performance. Why should we go for Enterprise Edition when Standard
> Edition has all the features required.
>

The Enterprise Edition offers improvements over the Standard Edition,
especially on parallel operations and caching. If you have a
significant amount of data you will defnitely notice a better
performance with this edition.

Regards,
lucm

[Back to original message]