SQL Server 2000 Enterprise Edition Datasheet
|
The following excerpts are taken from the SQL Server 2000 Enterprise Edition Datasheet. To read the entire datasheet, download the document using the link on the right side of this page.
Product Highlights
A comprehensive database and analysis solution, SQL Server 2000 delivers the performance, scalability, and reliability that demanding Web and enterprise line-of-business environments require. New Extensible Markup Language (XML) and Hypertext Transfer Protocol (HTTP) support simplify data access and interchange, while powerful analysis capabilities enhance data value. Enhanced availability features maximize uptime, advanced management functions automate routine tasks, and improved programming tools and services speed development.
Take advantage of tight integration with Microsoft .NET, the fastest way to integrate and Web-enable the enterprise.
SQL Server 2000 is the data management and analysis backbone for the coming wave of Microsoft .NET products and services.
Query, analyze, and manipulate data over the Web.
| • | Simplify the integration of back-end systems and data transfer across firewalls using rich SQL Server 2000 XML functionality and support for other Internet standards, such as XPath, XSL, and XSLT. Web developers can access data using XML without relational database programming, while database administrators can easily manipulate data in XML format using Transact-SQL (T-SQL) and stored procedures. |
| • | Connect to SQL Server 2000 databases and Online Analytical Processing (OLAP) cubes flexibly using the Web with no additional programming. Use secure HTTP database connectivity to ensure that data can be queried, even by novice developers, through a URL and intuitive user interfaces. |
| • | Derive additional value from data using sophisticated data mining tools that allow you to recognize trends and make predictions from the largest data sets. |
| • | Obtain results quickly using Microsoft English Query, which allows users to pose questions in English instead of using Structured Query Language (SQL) or Multidimensional Expressions (MDX). Enhanced full-text search now allows users to search unstructured data such as Microsoft Word documents, Web pages, or Microsoft Excel spreadsheets. |
| • | Create business-to-business (B2B) and business-to-consumer (B2C) Web sites, analyze Web site trends, and implement personalization automatically using Microsoft Commerce Server 2000 and SQL Server 2000. |
| • | Enable online exchanges between trading partners using Microsoft BizTalk® Server 2000 and SQL Server 2000. Web-enable and integrate existing business systems through pervasive XML support. |
Grow without limits with enhanced scalability and reliability features.
| • | Partition workload among multiple servers with distributed partitioned views, a new data tier "scale-out" feature that distributes data among a group of servers and coordinates query processing. As your business grows, you can add servers for even greater scalability. |
| • | Achieve scalability for mission-critical, line-of-business applications with support for large symmetric multiprocessing (SMP) systems with up to 32 processors and 64 gigabytes (GB) of RAM. Improve overall system performance with built-in support for a system area network (SAN). |
| • | Grow data warehouses and reporting solutions with indexed (materialized) views, distributed partitioned cubes, and support for dimensions with hundreds of millions of members. Indexed views improve performance by storing result sets so they do not have to be regenerated for future access. Distributed partitioned cubes improve performance by allowing access to cubes stored on multiple systems. |
| • | Maximize availability through fully integrated log shipping and enhanced failover clustering. Log shipping automatically synchronizes physically separated databases by sending transaction logs from one server to another. SQL Server 2000 and its tools are now fully cluster-aware to simplify management. Failover and failback can occur between any nodes in clusters of up to four nodes. |
| • | Take full advantage of your hardware resources by running multiple, isolated applications on a single computer using SQL Server 2000 multi-instance support. |
Build applications rapidly, and make sure they stay up and running.
| • | Centralize, automate, and reduce the costs of management using the Microsoft Windows® 2000 Active Directory™ service and SQL Server 2000 dynamic self-management and tuning. Copy and move databases among servers or instances with no downtime using the new Copy Database Wizard. |
| • | Deliver robust, scalable database applications rapidly using the improved SQL Server 2000 development tools. SQL Query Analyzer now includes a stored procedure debugger. Data Transformation Services (DTS) expand the ability to move and transform data from any source. |
| • | Improve productivity with T-SQL enhancements. New user-defined functions allow code reuse and simplify development. Maintain consistent data with cascading referential integrity to control the propagation of delete and update operations. |
| • | Take advantage of complete, end-to-end analysis capabilities—including data mining—with the integrated SQL Server 2000 extensible Analysis Services. New dimension types support data sets with a wide variety of hierarchies. Flexible security features protect data at the cube, member, or cell level. |
