MSSQL -node-net database design

Enterprise (64-bit) Edition Enterprise Edition Standard Edition Workgroup Edition

Overview Enterprise Edition (64-bit) provide the most scalable data platform to take advantage of the class of Intel Itanium-based servers. Addressing more memory than any other edition of SQL Server, it scales to the performance levels required to support the largest Data warehousing and analysis applications, ecommerce websites and Enterprise business systems. Supporting up to 8 nodes in failover clustering, SQL Server 2000 (64-bit) provides a high level of reliability and availability for your mission-critical applications. Enterprise Edition includes the complete set of SQL Server data management and analysis features and is uniquely characterized by several features that make it the most scalable and available edition of SQL Server 2000. It scales to the performance levels required to support the largest Web sites, Enterprise Online Transaction Processing (OLTP) systems and Data Warehousing systems. Its support for failover clustering also makes it ideal for any mission critical line-of-business application. Additionally, this edition includes several advanced analysis features that are not included in SQL Server 2000 Standard Edition.

There are four main areas in which the additional features of SQL Server 2000 Enterprise Edition are most evident:

Scalability

Availability/uptime

Performance

Advanced analysis

Standard Edition is the data management and analysis platform for small and medium-sized organizations. It includes the essential functionality needed for e-commerce, data warehousing, and line-of-business solutions. Standard Edition’s integrated business intelligence features provide organizations with the capabilities needed to manage and analyze their data.

Reporting Services provides robust business intelligence features. Analysis Services provides data mining features and the core OLAP (On-Line Analytical Processing) functionality.

Standard Edition includes all of the features of Workgroup Edition plus the following:

Analysis Services

Data Transformation Services (DTS)

Reporting Services

SQL Profiling and performance analysis tools

Workgroup Edition is the data management solution for small organizations or workgroups within larger entities. It includes all of the core database features needed for data management in an easy-to-use, affordable and simple to manage package. Workgroup Edition is ideal for the small organization for line-of-business (LOB), local data store, and e-commerce solutions.

All of the management features that make SQL Server easy to support and simple to manage are included in Workgroup Edition.

Workgroup Edition includes key features that allow you to easily manage and organize your data:

Enterprise Manager

Full-Text Search

Import/Export

Replication (snapshot, transactional, and merge)

Stored procedure development and debugging tools

Operating Systems Windows Server 2003 Enterprise Edition
Windows Server 2003 Datacenter Edition
Windows Server™ 2003, Standard Edition*
Windows Server™ 2003, Enterprise Edition*
Windows Server™ 2003, Datacenter Edition*
Windows® 2000 Server
Windows® 2000 Advanced Server
Windows® 2000 Datacenter Server
Windows Server 2003, Standard Edition*
Windows Server 2003, Enterprise Edition*
Windows Server 2003, Datacenter Edition*
Windows 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server
Windows Server 2003, Standard Edition*
Windows Server 2003, Enterprise Edition*
Windows Server 2003, Datacenter Edition*
Windows 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server
Windows XP

Scalability Up to 64 Processors
Up to 512 GB of Memory
Maximum database size 1,048,516 terabytes
Up to 32 Processors
Up to 64 GB of Memory
Maximum database size 1,048,516 terabytes
Up to 4 Processors
Up to 2 GB of Memory
Maximum database size 1,048,516 terabytes
Up to 2 Processors
Up to 2 GB of Memory
Maximum database size 1,048,516 terabytes

	Enterprise (64-bit) Edition	Enterprise Edition	Standard Edition	Workgroup Edition
Overview	Enterprise Edition (64-bit) provide the most scalable data platform to take advantage of the class of Intel Itanium-based servers. Addressing more memory than any other edition of SQL Server, it scales to the performance levels required to support the largest Data warehousing and analysis applications, ecommerce websites and Enterprise business systems. Supporting up to 8 nodes in failover clustering, SQL Server 2000 (64-bit) provides a high level of reliability and availability for your mission-critical applications.	Enterprise Edition includes the complete set of SQL Server data management and analysis features and is uniquely characterized by several features that make it the most scalable and available edition of SQL Server 2000. It scales to the performance levels required to support the largest Web sites, Enterprise Online Transaction Processing (OLTP) systems and Data Warehousing systems. Its support for failover clustering also makes it ideal for any mission critical line-of-business application. Additionally, this edition includes several advanced analysis features that are not included in SQL Server 2000 Standard Edition. There are four main areas in which the additional features of SQL Server 2000 Enterprise Edition are most evident: Scalability Availability/uptime Performance Advanced analysis	Standard Edition is the data management and analysis platform for small and medium-sized organizations. It includes the essential functionality needed for e-commerce, data warehousing, and line-of-business solutions. Standard Edition’s integrated business intelligence features provide organizations with the capabilities needed to manage and analyze their data. Reporting Services provides robust business intelligence features. Analysis Services provides data mining features and the core OLAP (On-Line Analytical Processing) functionality. Standard Edition includes all of the features of Workgroup Edition plus the following: Analysis Services Data Transformation Services (DTS) Reporting Services SQL Profiling and performance analysis tools	Workgroup Edition is the data management solution for small organizations or workgroups within larger entities. It includes all of the core database features needed for data management in an easy-to-use, affordable and simple to manage package. Workgroup Edition is ideal for the small organization for line-of-business (LOB), local data store, and e-commerce solutions. All of the management features that make SQL Server easy to support and simple to manage are included in Workgroup Edition. Workgroup Edition includes key features that allow you to easily manage and organize your data: Enterprise Manager Full-Text Search Import/Export Replication (snapshot, transactional, and merge) Stored procedure development and debugging tools
Operating Systems	Windows Server 2003 Enterprise Edition Windows Server 2003 Datacenter Edition	Windows Server™ 2003, Standard Edition* Windows Server™ 2003, Enterprise Edition* Windows Server™ 2003, Datacenter Edition* Windows® 2000 Server Windows® 2000 Advanced Server Windows® 2000 Datacenter Server	Windows Server 2003, Standard Edition* Windows Server 2003, Enterprise Edition* Windows Server 2003, Datacenter Edition* Windows 2000 Server Windows 2000 Advanced Server Windows 2000 Datacenter Server	Windows Server 2003, Standard Edition* Windows Server 2003, Enterprise Edition* Windows Server 2003, Datacenter Edition* Windows 2000 Server Windows 2000 Advanced Server Windows 2000 Datacenter Server Windows XP
Scalability	Up to 64 Processors Up to 512 GB of Memory Maximum database size 1,048,516 terabytes	Up to 32 Processors Up to 64 GB of Memory Maximum database size 1,048,516 terabytes	Up to 4 Processors Up to 2 GB of Memory Maximum database size 1,048,516 terabytes	Up to 2 Processors Up to 2 GB of Memory Maximum database size 1,048,516 terabytes