Diagnose partitioning related data movement between file groups using Extended Events and Debug Symbols
The concept of a sliding window scenario is to manage and keep the same number of partitions on a partitioned table over time. Learn how in this step-by-step from Arshad Ali.
This article discusses using Filtered Indexes as a simple partitioning strategy in SQL Server Standard Edition
Partitioning has improved with each new version of SQL Server. From partitioned views in SQL Server 7.0 through partition table parallelism in SQL Server 2008. With SQL Server 2012, we are now allowed to even create up to a 15K partition on a single table.
Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell
Part 2 of a series on how to automate partition management. In this article learn how easy managing and maintaining a sliding window partition scheme can be with PowerShell.