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.