A Tale of Partition Schemes and Disappearing Dragons

A tale in which is detailed how I used SWITCH PARTITION to efficiently load my data and save myself from the flaming jaws of death.

Maximum number of supported Partitions in SQL 2014

Table Partitioning –XE Diagnostic for Data Movements

Diagnose partitioning related data movement between file groups using Extended Events and Debug Symbols

Partitioning in SQL Server: Managing Sliding Window Scenario

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.

Filtered Indexes - Simple Partitioning without Enterprise Edition?

This article discusses using Filtered Indexes as a simple partitioning strategy in SQL Server Standard Edition

Partitioning in SQL Server - Part 3

Arshad Ali provides a step-by-step guide to create a partitioned table/index.

Partitioning in SQL Server

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.

Partitioned index

SQL Partition

Automate Sliding Window Partition Maintenance: Part III

Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell