Evidence of their 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. Under the most demanding reporting scenarios, indexed views can mean dramatic performance gains. 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.
Materialized views improve performance and scalability by storing and updating data to disk.
With SQL Server 2000, a robust set of tools help you to leverage the most value out of the data you collect and store. Tight integration with Microsoft Office 2000 means that users can perform sophisticated analysis on large data sets using familiar tools. This important upgrade puts the power of analysis in the hands of more people than ever. Microsoft Excel 2000 in particular provides rich access to SQL Server 2000 data, allowing workers to create dynamic views of OLAP cubes using Microsoft PivotTable functionality. Excel 2000 also makes it easy for any user to save a spreadsheet, chart, or PivotTable as a Web page, enabling other users to access and analyze SQL Server data.