Using Partitions
As with indexes, partitions require proper usage. In this section, you will learn how to best take advantage of partitions and how to properly use partitions. Later in this chapter, you will also be presented with a number of scenarios in which partitioning is useful and can help improve the performance of your system.
Inserting Data into Partitioned Tables
Inserting data into a partitioned table is completely automatic. The data is routed to the correct partition without any intervention by the SQL Server engine. Simply insert data into the table.
Selecting Data from Partitioned Tables
Selecting data from a partitioned table is as simple as inserting data into the partitioned table. As with insertion, data is automatically selected ...
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.
