IBM Certification Exams

Understanding SQL Server 2005 Editions
A major part of the installation planning process is determining the SQL Server 2005
edition you need to use. 70-541 70-630 SQL Server 2005 offers five editions—two of which come in
either 32-bit or 64-bit versions—each designed for a specific environment. Determining
the proper edition to install is critical for meeting the functionality needs of your
current environment as well as any future needs you might expect. Here is a description
of each edition:
SQL Server 2005 Enterprise Edition (32-bit and 64-bit) Enterprise Edition is
designed to support the largest enterprise online transaction processing (OLTP)
environments, highly complex data-analysis requirements, data-warehousing
systems, and active Web sites. DBAs designing large database installations
should consider only Enterprise Edition.
SQL Server 2005 Standard Edition 70-640 70-647 MB2-631 (32-bit and 64-bit) Standard Edition includes
the essential functionality needed for e-commerce, data warehousing, and lineof-
business solutions that most small- and medium-sized organizations use.
Organizations with databases that will contain large amounts of data but do not
need installations with all the features of Enterprise Edition might want to consider
Standard Edition.
SQL Server 2005 Workgroup Edition (32-bit only) Workgroup Edition is the datamanagement
solution for small organizations that need a database that has no
limits on size or number of users and has the capability to serve as a back end to
small Web servers and departmental or branch-office operations. DBAs working
with small amounts of data on smaller servers might want to consider using
Workgroup Edition.
SQL Server 2005 Developer Edition (32-bit and 64-bit) Developer Edition includes
all the functionality of SQL Server 2005 Enterprise Edition, but it is licensed for
use as a development and test system, not as a production server. Developer Edition
is suited for developers in larger companies who need to develop applications
that will use Enterprise Edition but who do not want to install Enterprise
Edition on development or test servers.
SQL Server 2005 MB2-633 1Y0-259 Express Edition (32-bit only) SQL Server Express is a free, easyto-
use, and simple-to-manage database that can be redistributed to function as
the client database as well as a basic server database. Express Edition is usually
suited only for very small data sets. Developers who are developing applications
that require a small data store should consider using Express Edition. Express
Edition also makes a suitable replacement for Microsoft Access databases.
Lesson Summary
SQL Server 2005 includes five editions: Enterprise Edition, Developer Edition,
Standard Edition, Workgroup Edition, and Express Edition.
Enterprise Edition has no limitations and contains all features and functionality.
Developer Edition has no limitations and contains all features and functionality,
but it is not licensed for production.
Standard Edition has features and functionality suited for larger data sets, but it
is limited in the number of nodes it supports for clustering as well as in its capability
to use system resources, online indexing, indexed views, fast recovery,
online restores, and data partitioning.
Native Support 1Y0-731 1Z0-042 220-602
for Web Services
(Service Oriented
Architectures)
Yes
(Reporting
Services
only)
Yes (Reporting
Services
only)
Yes Yes
Analysis Services No No Yes Yes
Table 1-1 Feature Set by SQL Server 2005 Edition (Developer Edition has the same
feature set as Enterprise Edition)
Feature/Functionality
Express Workgroup Standard Enterprise
8 Chapter 1 Installing SQL Server 2005
Workgroup Edition does not include the features and functionality needed to
operate large databases and is restricted in its capability to support mid-size and
large companies. 640-801 640-822
Express Edition is useful for small application-installed databases that need to
be distributed free of charge. It is not suited for organization-wide databases.

Share This

Related posts:

1. Testking demo 70-536 certification guides Product Description Exam Number/Code: 70-536 Exam Name: TS:MS.NET Framework 2.0-Application...
2. Testking demo 70-297 practice Product Description Exam Number/Code: 70-297 Exam Name: MCSE Designing a...
3. Testking demo Microsoft 70-299 exam demo download Product Description Exam Number/Code: 70-299 Exam Name: MCSA 2003 Implementing...
4. Microsoft MCDBA 70-229 exam Microsoft’s exam 70-229, Designing and Implementing Databases with Microsoft SQL...
5. Testking demo 642-432 practice detail Product Description Exam Number/Code: 642-432 Exam Name: CCVP Cisco Voice...