SQL Standard versus Enterprise

#21

I think in SQL Server 2008 Standard Edition and Enterprise Edition; you do
have perforamce difference as with the functionality you have access to.

Since you will have lots of page views, you could gain advantage from
partitioned tables if your database is large. Also Enterprise edition lets
you have full Database Mirroring which can provide for HA solution.

For example:
- Partitioned Tables and Indexes
- Memmroy
- CPU
- Parallel index operations

Offical List of Feature Compare:
http://download.microsoft.com/downlo...seStandard.pdf
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

"Tecnica" wrote:

Quote:

Hi,

Is there a way to prove, or not, that under the same hardware configuration
with the same databases SQL Server Enterprise is faster than the Standard?
What is the best and faster SQL 2008 version for serving a web site with
more than 1 milion pageviews a day?

Thanks,
Rui Reis

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Standard versus Enterprise

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

RE: SQL Standard versus Enterprise - 10-28-2008 , 02:11 PM