Chapter 49
Partitioning
In This Chapter
Scaling Out with Multiple Tables and Multiple Servers
Using Distributed Partition Views
Exploring Table Partitioning
Creating Custom Partitioning Design
When working with large tables — in terabytes — you are often posed with several challenges. How can you mitigate those problems? Division.
Dividing data brings several benefits:
- It's significantly easier to maintain, back up, and defragment a divided data set.
- The divided data sets mean smaller indexes, fewer intermediate pages, and faster performance.
- The divided data sets can reside on separate physical servers, thus scaling out and lowering costs and improving performance.
However, dividing, or partitioning, data has its own set of problems to conquer. You can solve this problem in several ways. SQL Server offers a couple of technologies that handle partitioning: partitioned views and partitioned tables.
Get Microsoft SQL Server 2012 Bible 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.
