O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 19. Data Partitioning

Data partitioning is the process of dividing, or partitioning, a table into smaller, more manageable pieces. Data partitioning exists in two forms: horizontal partitioning and vertical partitioning. Horizontal partitioning is where a table with a large number of rows is split into multiple partitions, each with the same number of columns but fewer rows. Vertical partitioning is where a table with a large number of columns or very large columns is split into multiple partitions, each with the same number of rows but fewer columns.

Vertical partitioning appears ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required