Summary
In this chapter, you learned about SQL Server 2005 table and index partitioning. This partitioning works on a range of values and will store the data in the proper partition based on the contents of the partition column. SQL Server 2005 partitioning benefits the database in several ways. By working in conjunction with SQL Server Query Optimizer, only the necessary partitions will be accessed. This helps with the primary goal of performance tuning—reducing the amount of data being accessed.
Data partitioning has existed in a primitive form since SQL Server 7.0 and SQL Server 2000 using the UNION ALL view. As mentioned earlier, the UNION ALL view multiple tables are created, each with the same data structure, and are joined together with ...
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.
