Creates a function in the current database that maps the rows of a table or index into partitions based on the values of a specified column. Using CREATE PARTITION FUNCTION is the first step in ...

Any one of the following permissions can be used to execute DROP PARTITION FUNCTION: ALTER ANY DATASPACE permission. This permission defaults to members of the sysadmin fixed server role and the ...

SQL partitioning can be done based on different criteria, such as ranges, lists, hashes, or keys. For example, you can partition a table of sales records by date range, customer category, product ...