Performance
There are several new features and built-in support within SQL Server 2005 that provide potential for improved system performance and for monitoring performance. Data partitioning, the ability to partition table data and indexes into horizontal partitions, can help with performance and manageability of data. There are new query hints and query plan guides available to help improve performance and to improve query plan reuse. There are also new dynamic management system views for monitoring performance information. Each of these is described in the following sections.
Data Partitioning
Native table and index partitioning capabilities are new for SQL Server 2005 Enterprise Edition only. Partitioning can significantly improve query performance ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
