SQL Server – Distributing and Partitioning

Key Points of Distributing and Partitioning

• Partition allow you to divide a table or index into multiple filegroups.
• Table and index are partition horizontally, based on rows by specifying a partitioning column.
• To create a portioned table or index you need to perform the following actions:
• Create a partition function
• Create a partition schema mapped to partition function
• Create a table or index on the partition schema
• SPLIT function to add a new boundary point and hence partition.
• MERGE function to remove a boundary point and hence partition.
• SWITCH function to move a partition of data between tables.