O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required