Microsoft SQL Server 2000
Achieve the highest levels of performance and scalability for your databases
Business today demands a different kind of data management solution. Performance, scalability, and reliability are essential, but businesses now expect more from their key IT investments.
SQL Server 2000 exceeds dependability requirements and provides innovative capabilities that increase employee effectiveness, integrate heterogeneous IT ecosystems, and maximize capital and operating budgets. SQL Server 2000 provides the enterprise data management platform your organization needs to adapt quickly in a fast-changing environment.
With the lowest implementation and maintenance costs in the industry, SQL Server 2000 delivers rapid return on your data management investment. SQL Server 2000 supports the rapid development of enterprise-class business applications that can give your company a critical competitive advantage.
Benchmarked for scalability, speed, and performance, SQL Server 2000 is a fully enterprise-class database product, providing core support for Extensible Markup Language (XML) and Internet queries.
Active Solutions can supply, configure and install Microsoft SQL Server to meet your requirements. Call 0870 112 0887 to discuss further.
Easy-to-Use Business Intelligence (BI) Tools
Through rich data analysis and data mining capabilities that integrate with familiar applications such as Microsoft Office, SQL Server 2000 enables you to provide all of your employees with critical, timely business information tailored to their specific information needs. Every copy of SQL Server 2000 ships with a suite of BI services.
Self-Tuning and Management Capabilities
Revolutionary self-tuning and dynamic self-configuring features optimize database performance, while management tools automate standard activities. Graphical tools and wizards simplify setup, database design, and performance monitoring, allowing database administrators to focus on meeting strategic business needs.
Data Management Applications and Services
Unlike its competitors, SQL Server 2000 provides a powerful and comprehensive data management platform. Every software license includes extensive management and development tools, a powerful extraction, transformation, and loading (ETL) tool, business intelligence and analysis services, and new capabilities such as Notification Services. The result is the best overall business value available.
| 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 an affordable option for small and medium-sized organizations. It includes the core functionality needed for non-mission-critical e-commerce, data warehousing, and line-of-business solutions. For instance, all of the XML features present in Enterprise Edition are also included in Standard Edition. And while a handful of advanced OLAP features are reserved for Enterprise Edition, all data mining features and the core OLAP functionality are included in SQL Server 2000 Analysis Services in Standard Edition.
Similarly, components that other database vendors charge for as separate add-on products for their highest-end editions are included in Standard Edition:
- Data Transformation Services (DTS)
- Replication (snapshot, transactional, and merge)
- Full-Text Search
- English Query
- Stored procedure development and debugging tools
- SQL Profiling and performance analysis 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 NT® Server 4.0
Windows NTServer® 4.0 Enterprise 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 NT Server 4.0
Windows NT Server 4.0 Enterprise Edition
|
| 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
|
| Overview |
Developer edition is designed to allow developers to build any type of application on top of SQL Server. It includes all the functionality of Enterprise Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment. It is the ideal choice for Independent Software Vendors (ISVs), consultants, system integrators, solution providers, and corporate developers developing and testing applications because it is cost effective, runs on a variety of platforms, and can be upgraded for production use to SQL Server 2000 Enterprise Edition.
It is the only edition of SQL Server 2000 that gives the licensee the right to download and install SQL Server 2000 Windows CE Edition (SQL Server CE). The Developer Edition licensee also has the right to redistribute SQL Server CE-based applications to an unlimited number of devices at no additional cost beyond the purchase price of SQL Server 2000 Developer Edition.
|
Personal Edition is ideal for mobile users who spend some of their time disconnected from the network but run applications that require SQL Server data storage, and for stand-alone applications that require local SQL Server data storage on a client computer. This edition is functionally equivalent to Standard Edition, with the following exceptions:
- It includes a concurrent workload governor that limits its scalability; performance degrades when more than five Transact-SQL batches are executed concurrently.
- It cannot act as a transactional replication publisher (subscriber only).
|
SQL Server 2000 Desktop Engine (MSDE 2000) is a free, redistributable version of SQL Server. Third-party software developers can include it in applications they build that use SQL Server to store data.
MSDE is an ideal solution for:
- Client applications that require an embedded database.
- Basic websites that serve up to 25 concurrent users.
- New developers who are learning how to build data-driven applications.
This edition is functionally equivalent to Standard Edition with the following exceptions:
- Does not include graphical management tools (Enterprise Manager).
- Has a workload governor that limits the number of concurrent transactions.
- Does not include any analysis capabilities (such as OLAP, DTS, data mining, and data warehousing features).
- Has different scalability limits.
|
Windows CE Edition (SQL Server CE) is the compact database for rapidly developing applications that extend enterprise data management capabilities to devices. SQL Server CE is a full-fledged member of the SQL Server 2000 family, with tools, application programming interfaces (APIs), and SQL grammar that developers and database administrators with existing SQL Server skills will recognize. SQL Server CE is the only edition of SQL Server 2000 that provides relational database management capabilities on Windows CE-based devices.
The SQL Server CE engine provides an essential set of relational database features, including:
- an optimizing query processor
- support for transactions
- support for assorted data types
- a compact footprint that preserves system resources
- Remote data access and merge replication over Hypertext Transfer Protocol (HTTP)
|
| Operating Systems |
Windows Server 2003 Standard Edition*
Windows Server 2003 Enterprise Edition*
Windows Server 2003 Datacenter Edition*
Windows® XP Professional
Windows® 2000 Professional
Windows 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server
Windows NT Workstation
Windows NT Server 4.0
Windows NT Server 4.0 Enterprise Edition
|
Windows Server 2003, Standard Edition*
Windows Server 2003, Enterprise Edition*
Windows Server 2003, Datacenter Edition*
Windows XP Professional
Windows 2000 Professional
Windows 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server
Windows NT Workstation
Windows NT Server 4.0
Windows NT Server 4.0 Enterprise Edition
|
Windows Server 2003, Standard Edition*
Windows Server 2003, Enterprise Edition*
Windows Server 2003, Datacenter Edition*
Windows XP Professional
Windows XP Home
Windows 2000 Professional
Windows 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server
Windows NT Workstation
Windows NT Server 4.0
Windows NT Server 4.0 Enterprise Edition
|
Windows CE version 2.11 or later
- Handheld PC Pro (H/PC Pro)
- Palm-size PC (P/PC)
- Pocket PC
|
| Scalability |
Up to 32 Processors
Up to 64 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 |
Up to 2 Processors
Up to 2 GB of Memory
Maximum Database Size 2 GB |
1 Processor
Maximum Database Size 2 GB |