Microsoft SQL Server 2000 Enterprise Features
Microsoft SQL Server 200 Enterprise provides you with advanced abilities to organize, develop, maintain, and analyze your data. With new features that make the server and its programs more flexible, there is still a great deal to recommend the 2000 edition of the server, even all these years later.
User-Defined Functions—For the first time, Microsoft has expanded the functions it offers with user-defined functions. These allow you to set multiple parameters that will then return a single value, whether it’s a scalar value or a result set that comes in table form. The table values can be used for more complex equations.
Indexed Views—Microsoft SQL Server 2000 Enterprise lets you store views in your database in the same way you can store tables. These indexed views can then improve application performance by easing the amount of work the query process has to do to resolve the views.
Expanded partitioned view abilities—New partitioned viewing abilities on Microsoft SQL Server 2000 Enterprise make it possible for the first time to partition a table horizontally across multiple SQL Servers. You can then keep all your data looking like it came from one table on that original server while you scale it out to multiple database servers. This feature can be updated for even more abilities.
INSTEAD OF and AFTER triggers—These triggers provide more flexibility when coding on the server. As the terms suggest, they can allow an action to execute either AFTER an operation (there are can be multiple AFTER triggers) or INSTEAD of a different operation.
New table datatype—Now, for the first time, you can store temporary results as a table and get many of the benefits that come with it. The table datatype lets you select statement or run action queries just like you would with a normal user table.
Store text and image more efficiently—Previous editions of the Microsoft SQL Server always saved text and image data separately from where the data row was. The data row only pointed to the text and image page chain where the data was saved. For small text and image files, this has now been changed, with the benefit of potentially less space required for storage.
Cascading DRI automation—This basic automation is incredibly useful for database upkeep. With Cascading Declarative Referential Integrity, you can create a relationship between a parent and dependent table that bears fruit when you update or delete rows from that parent table. Once that is done, the automation takes over to do the same on the dependent table, making it easier to keep all your tables up to date.
Multiple SQL Server instances for much expanded server abilities—Previous versions of the SQL Server only allowed you to run one instance at a time. The 2000 edition makes it possible to run multiple instances with each one running independently. That means it has its own databases, security, and other specifications. Applications can choose which instance to connect to.
XML included for more web work—With Extensible Markup Language (XML) included on the Microsoft SQL Server 2000 Enterprise, it is now easier to work with web-based programming. It allows you to describe your datasets and decide how they should be displayed on the web. This allows for a far stronger connection between the web and the SQL Server. XML documents can allow be directly inserted into SQL Server tables.
Log shipping for database backup—With log shipping enabled and simplified in the Microsoft SQL Server 2000 Enterprise edition, you can now have a primary database set up with read/write capabilities and then one or more read-only copies that sync to that primary database to stay up to date. Essentially, that allows you to have copies of your database easily accessible if you ever experience a database failure. You can also do all your read-only querying on copies to avoid all that query processing on the primary database.