Shared Flashcard Set

Details

ch 1SQL Sever 2005 Features
by edition
26
Other
Professional
09/25/2008

Additional Other Flashcards

 


 

Cards

Term
Number of CPU's Suppoted
Definition

Express - includes support for multicore processor

Workgroup - Includes support for multicore processor

Standard - Includes support for multicore processor

Enterprise - Unlimited includes support for multicore processor

Term
Memory
Definition

Express - 1GB

Workgroup - 3 GB

Standard - Limited based on operating system

Enterprise Limit based on operating system

Term
64-bit support
Definition

express - with windows on windows aka WOW

workgroup - with WOW

standard - native

enterprise - native

Term
Maximum database size
Definition

express -  4GB

workgroup - no limit

standard - no limit

enterpri - no limit

Term
partitioning
Definition
only enterprise edition
Term
Database Mirroring
Definition
only Standard and enterprise editions
Term
Failover clustering
Definition

standard yes 2 nodes only

enterprise  yes

Term
Log Shipping
Definition
yes on workgroup, standard and enterprise editions
Term
Management studio
Definition
yes on workgroup, standard and enterprise editions
Term
database advisor
Definition
yes on standard and enterprise editions
Term

Full text search

Definition
yes on workgroup, standard and enterprise editions
Term
SQL Server agent job scheduling service
Definition
yes on workgroup, standard and enterprise editions
Term
best practices analyzer
Definition
yes on all editions
Term
Notification services
Definition
yes on standard and enterprise editions
Term
Service Broker
Definition

yes on workgroup, standard and enterprise editions

Express subsciber only

Term
Merge replication
Definition

express -  subscriber only

workgroup - yes publish up to 25 subscribers

standard - yes

enterprise - yes

Term
Transaction replications
Definition

express - yes subscriber only

workgroup - yes publish up to five subscribers

standard - yes

enterprise - yes

Term
Oracle replications
Definition

only on enterpise

trasactioanl replications with an oracle database as a publisher

Term

Web services

HTTP endpoints

 

Definition
yes with standard and enterprise
Term
report server
Definition
yes on all editions
Term
report builder
Definition
yes on all except express
Term
BI development studio
Definition

express - yes report designer only

workgroup - yes report desiner only

standard - yes

enterprise - yes

Term

enterprise management tools

Definition
yes on all editions except Express
Term
Native Support for Web Services
Definition

express - yes reporting services only

workgroup - yes reporting services only

standard - yes

enterprise - yes

Term
Analysis Services
Definition
yes on standard an enterprise editions
Supporting users have an ad free experience!