|Internet standards support||Integrate existing systems without programming through comprehensive support for W3C standards including XML, Xpath, XSL and HTTP.|
|XML Views||View and access relational data using XML techniques by easily mapping XML elements and attributes to relational schema.|
|URL and HTTP access||Flexibly access data from the Web via a URL. Use Structured Query Language (SQL), XML templates or XPath in URLs for querying.|
|SELECT . FOR XML||Return XML from SQL queries and easily control the shape of the returned XML tree with three formatting options.|
|OpenXML||Access, manipulate and update XML documents as if they were tables using T-SQL and stored procedures.|
|XML Updategrams - available through download after release||Use XML to selectively insert, update and delete table data from anywhere, even through firewalls|
|XML bulk load - available through download after release||Seamlessly transmit, transform and load data from any source into SQL Server 2000 relational tables.|
|Integrated Data Mining||Analyze collected relational and OLAP data including clickstreams and purchase histories to recognize trends and make predictions. Close the loop by delivering personalized content.|
|HTTP access to cubes||Make cubes available through firewalls for Web-based analysis applications using an HTTP listener built into SQL Server 2000 Enterprise Edition.|
|Multi-instance support||Run reliably in hosted scenarios with separate database instances per customer or application.|
|Installation disk imaging||Create standard or default databases for server farms easily and rapidly from any machine on the network with built-in cloning technology|
|Distributed Partitioned Views||Achieve software scale out on the data tier by partitioning workload across servers. Add additional servers for greater scalability.|
|Log Shipping||Automatically keep databases in synch for warm standby on multiple backup servers to share load no matter how physically far apart.|
|Parallel index creation||Take full advantage SMP hardware to speed up index creation, easing the load on frequently updated systems.|
|Parallel scan||Accelerate scans on multi-processor systems to improve overall database performance.|
|Failover cluster management||Reinstall or rebuild any node in a failover cluster without impacting other nodes. Easily configure fail over for replication and Distributed Partitioned Views.|
|32 CPU SMP system support - Requires Windows 2000 DataCenter Server||Scale-up SQL Server 2000 databases to SMP systems with as many as 32 processors.|
|64 GB RAM support - requires Windows 2000 Data Center Server||Handle the largest data sets and transactional loads with up to 64 GB of RAM for SQL Server 2000.|
|VI SAN support||Speed communications between servers with SQL Server 2000 support for direct communication with System Area Network (SAN) devices.|
|Indexed views||Create indexes on views to improve performance of existing queries without recoding. Speed up analysis and reporting that rely on complex views.|
|ROLAP dimension storage||Perform analyses on huge dimensions (10M+ members) by storing such dimensions relationally.|
|Distributed Partition Cubes||Easily use the Partition Wizard to separate one logical cube into separate physical partitions with complete transparency for flexible data storage and improved query performance.|
|Online index reorganization||Keep the server up and running while reorganizing indexes to improve performance.|
|Differential backup||Run backups quickly and with low server impact by only backing up changed pages.|
|Server-less snapshot backup5||Backup data seamlessly with effectively no impact on the database server. Restore quickly or create warm standby servers. Requires third party virtual device interface (VDI) application and enterprise storage system supporting split mirror or copy-on-write operations.|
|MDX Builder||Use drag-and-drop to quickly generate Multidimensional Expressions. Easily add functions, arithmetic operators and more.
Fully Web-Enabled...Query, analyze and manipulate data over the Web. Use Extensible Markup Language (XML) in SQL Server 2000 to exchange data between loosely coupled systems. Access data easily and securely from a browser, through firewalls, and perform fast full-text searches of formatted documents. Analyze and link online analytical processing (OLAP) cubes, even over the Web. Perform click stream analysis to learn about your Web customers.
Highly Scalable and Reliable...Grow without limits with enhanced scalability and reliability features. Partition your database workload to achieve scale-out of applications. Take full advantage of Symmetric Multiprocessing (SMP) hardware, and, with the Microsoft Windows 2000 Data center. Server operating system, support up to 32 CPUs and 64 GB of RAM.
Fastest Time-to-Market...Rapidly build, deploy, and manage e-commerce, line-of-business, and data warehousing solutions. Perform sophisticated data mining on customer and financial data. Reduce development time with the integrated T-SQL debugger, and develop your own functions that can be reused in different applications. SQL Server 2000 provides the fastest route to Web application development.
| System Requirements
|SQL Server 2000, all editions|
|Computer/Processor||Intel« or compatible. Pentium 166 MHz or higher, Pentium PRO, Pentium III, or the minimum processor required for your operating system, which varies for SQL Server editions.|
Note Microsoft SQL Server 2000 does not have a hardware compatibility list (HCL). If your system meets the minimum requirements listed above, SQL Server 2000 software works on the hardware certified for use with the Microsoft Windows« operating system you are using. For information about the hardware certified for use with your Windows operating system, see the HCL for your version of Windows.
- Enterprise Edition: 64 MB minimum 64 GB
- Standard Edition: 32 MB minimum
- SQL Server 2000, full install: 180 MB
- SQL Server 2000, typical install: 170 MB
- SQL Server 2000, minimum install: 65 MB (minimum)
- SQL Server 2000, client tools only: 90 MB
- Analysis Services: 50 MB
- English Query: 12 MB
|Operating System||Note On Microsoft Windows NT« Server 4.0, Service Pack 5 (SP 5) or later must be installed as a mimimum requirement for all SQL Server 2000 editions. |
- Enterprise Edition. Microsoft Windows NT Server 4.0 (Microsoft Windows NT Server Enterprise Edition 4.0, Windows 2000 Advanced Server, and Windows 2000 Data Center Server).
Note: Microsoft Windows 2000 Server is required for some SQL Server 2000 features.
- Standard Edition. Microsoft Windows NT Server 4.0, Windows 2000 Server, Microsoft Windows NT Server Enterprise Edition, Windows 2000 Advanced Server, and Windows 2000 Data Center Server.
- Personal Edition. Microsoft Windows 98, Windows NT Workstation 4.0, Windows 2000 Professional, Microsoft Windows NT Server 4.0, Windows 2000 Server, and all the more advanced Windows operating systems.
- Developer Edition. Windows NT Workstation 4.0, Windows 2000 Professional, and all other Windows NT and Windows 2000 operating systems.
|Miscellaneous||To insall Client Tools Only Windows NT 4.0, Windows 2000 (all versions), and Windows 98.|
To install Connectivity Only
Windows NT 4.0 or Windows 2000, Windows 98, and Windows 95.
Internet software Microsoft Internet Explorer 5.0 is required for all installations of Microsoft SQL Server 2000, except for the Connectivity Only option, which requires Microsoft Internet Explorer 4.01 with Service Pack 2. Internet Explorer is required for Microsoft Management Console (MMC) and HTML Help. A minimal install is sufficient, and Internet Explorer does not need to be your default browser.
Internet Information Services If you are writing XML applications, see System Requirements for the IIS Virtual Directory Management for SQL Server Utility.
Network Software Requirements Microsoft Windows NT, Windows 2000, Windows 98, and Windows 95 have built-in network software. No other network software is required, unless you are using Banyan VINES or AppleTalk ADSP.
Novell NetWare client suppor