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

Creating Partitions

Creating partitions is a three-step process. In the first step, a partition function is created. This function defines how the partitions will be formed by specifying how data is divided. The second step is creating the partition scheme. The partition scheme is used to define how the partitions will be physically defined in the database. The third and final step is creating the table or index that uses the partition scheme that you have developed.

Create the Partition Function

The partition function is used to define the criteria for dividing the data into the individual partitions. A partitioned table or index can be made up of as few as one partition (all objects are considered partitioned now) or as many as 1,000 partitions. ...

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