SQL Server 2014 introduces enhancements to two common database maintenance operations namely Partition Switching and Online Index Rebuild which greatly increases enterprise application availability by ...

Manage Partition Wizard [!INCLUDE SQL Server] Use the Manage Partition Wizard to manage and modify existing partitioned tables through partition switching or the implementation of a sliding window ...

DROP PROCEDURE IF EXISTS dbo.usp_switch_partition GO CREATE PROCEDURE dbo.usp_switch_partition @source_table_name sysname = 'EMPTY', @target_table_name sysname = 'EMPTY', @batch_id int = 0 AS BEGIN ...