Partition

Get-DbaDbPartitionFunction

Klaas Vandenberghe (@PowerDbaKlaas)

Get-DbaDbPartitionFunction View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves partition function definitions and metadata from SQL Server databases. Description Retrieves partition function definitions and their metadata from one or more SQL Server databases. Partition functions define how table or index data is distributed across multiple partitions based on the values of a partitioning column.

Get-DbaDbPartitionScheme

Klaas Vandenberghe (@PowerDbaKlaas)

Get-DbaDbPartitionScheme View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves partition schemes from SQL Server databases for table partitioning management. Description Retrieves partition scheme objects from one or more SQL Server databases, providing details about how partitioned tables and indexes are distributed across filegroups. Partition schemes define the physical storage mapping for partitioned tables by specifying which filegroups contain each partition’s data.

Remove-DbaDbPartitionScheme

Mikey Bronowski (@MikeyBronowski), bronowski.it

Remove-DbaDbPartitionScheme View Source Mikey Bronowski (@MikeyBronowski), bronowski.it Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes database partition schemes from SQL Server databases. Description Removes partition schemes from specified databases across one or more SQL Server instances. Partition schemes define how partitioned tables and indexes map to filegroups, and this function helps clean up unused schemes during database reorganization or migration projects.