Categories
Sql Server

How to create a partition scheme in Sql server

A partition scheme in database is that maps the partitions of a partitioned table or index to filegroups. The number and domain of the partitions of a partitioned table or index are determined in a partition function. A partition function must first be created in a CREATE PARTITION FUNCTION statement before partition scheme. Permission can […]