Partitioning

Learn about SQL Server Partitioning from these valuable tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.

Title Author Date
Manage Multiple Partitions in Multiple Filegroups in SQL Server Nitin Rana2026-05-10
SQL Server Table Partitioning and Query Performance Mehdi Ghapanvari2025-12-08
How to Partition an existing SQL Server Table Ben Snaidero2025-01-12
Pros and Cons of Database Sharding for Performance and Maintenance John Miner2022-12-26
Convert Large Table to Partitioned View in SQL Server John Miner2022-10-28
SQL Server Table Partitioning with Maximum 15,000 Partitions Aaron Bertrand2022-06-21
SQL Server Table Partitioning with a Columnstore Index Sean Lee2021-09-15
Partitioning Data in SQL Server without using Partitioned Tables Aaron Bertrand2019-08-27
Implementation of Sliding Window Partitioning in SQL Server to Purge Data Nat Sundar2018-02-22
SQL Server 2016 Truncate Table with Partitions Ahmad Yaseen2016-08-30
SQL Server Partition Wizard Brady Upton2013-01-09
Archiving SQL Server data using partitioning Ben Snaidero2012-10-11
Identify Overloaded SQL Server Partitions Ken Simmons2010-05-19
SQL Server Database Partitioning Myths and Truths Alan Cranfield2010-01-04
Creating a table with horizontal partitioning in SQL Server Atif Shehzad2009-07-17
Partitioning SQL Server Data for Query Performance Benefits Chad Boyd2008-03-19
Switching data in and out of a SQL Server 2005 data partition Greg Robidoux2008-01-07
Handling Large SQL Server Tables with Data Partitioning Greg Robidoux2007-03-15