Microsoft OLAP Actions, a new feature of Analysis Services, extends the power of business analysis with new functionality that allows knowledge workers to take the conclusions they reach and use them to automatically drive business processes. Great Scalability, Incomparable Performance Recognizing that scalability and performance are among the most critical issues that database administrators face today, the SQL Server 2000 development team focused heavily on building new features that guarantee outstanding speed and scalability into SQL Server 2000. Evidence of the development team's success is found in industry-standard benchmark tests, which demonstrate convincingly that SQL Server 2000 supports more users, handles more queries in less time, and achieves better scalability, all while running on incredibly affordable systems. For more information, visit the Enterprise-Scale Business Intelligence page. Under the most demanding reporting scenarios, indexed views can mean dramatic performance gains.
Indexed views work by allowing for the creation of a unique clustered index.
When the view is executed, the results are stored in the database, and queries can retrieve the data without having to be recoded. Data Transformation Services. Advanced Query Processing. SQL Server 2000 offers powerful new methods for executing intricate queries, including the ability to break a complex query into smaller component parts and distribute the workload among multiple processors. With SQL Server 2000, a robust set of tools help you to leverage the most value out of the data you collect and store.