What's New in Version 2000
Several of the key features found in SQL Server 2000 are as follows:
XML Support
Multi-Instance Support
Data Warehousing/Business Intelligence Improvements
Windows 2000 Support
Performance and Scalability Improvements
Wizard Improvements
Query Analyzer Improvements
DTS Improvements
Transact SQL Enhancements
XML Support
XML is becoming the standard in which businesses communicate and share information. SQL Server 2000 provides extensive XML support. XML support is easy to setup and access. Once you are up and running with XML, you can store XML inside a table, query the XML data through Transact-SQL statements, and even join XML data to relational data through a SQL statement.
Multi-Instance Support
Multi-Instance support enables ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
