1129
Chapter 49: Partitioning
49
Summary
Not every database needs to scale to higher magnitudes of capacity, but when a project does
grow into the terabytes, SQL Server 2012 provides some advanced technologies to tackle the
growth. However, even these advanced technologies are no substitute for smart database
design.Following are key points on partitioning:■ (^) Partitioned views use a union to merge data from several user-created base tables.
Each partition table must include the partition key and a constraint.
■ (^) The Query Processor can carefully choose the minimum number of underlying tables
when selecting through a partitioned view but not when updating.
■ (^) Partitioned tables are a completely different technology than partitioned views and
use a partition function, schema, and clustered index to partition a single table.
The next chapter wraps up this part covering optimization with features that are available
in the Enterprise Edition of SQL Server 2012.
c49.indd 1129c49.indd 1129 7/31/2012 10:24:25 AM7/31/2012 10:24:25 AM
http://www.it-ebooks.info