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.  Read more...

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

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

Recently, one of my favorite customers asked me some very thought-provoking questions about using database partitioning to move transactional data around. Their...  Read more...

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.  Read more...

Read more...

Read more...

In SQL Server 2008 and SQL Server 2008 R2, the number of partitions on tables and indexes is limited to 1,000. This paper discusses how SQL Server 2008 SP2 and SQL Server 2008 R2 SP1 address this limitation by providing an option to increase the limit to 15,000 partitions. It describes how support for 15,000 partitions can be enabled and disabled on a database. It also talks about performance characteristics, certain limitations associated with this support, known issues, and their workarounds. This support is targeted to enterprise customers and ISVs with large-scale decision support or data warehouse requirements.  Read more...

This view shows range limits, number of rows and filegroup for each partition for each table  Read more...

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

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.  Read more...

A new series on how you can automate partition management and administration. Hugh Scott explains how this technique helps him manage large deletes.  Read more...

This script automatically splits a partitioned table, merges the partition function and then drops the associated file group for the partition.  Read more...

This script automatically splits a partitioned table, merges the partition function and then drops the associated file group for the partition.  Read more...

Given some input parameters, it generates the filegroups, files, partition function and partition scheme sql statements.  Read more...

Table partitioning was added in SQL Server 2005 and increases performance in most cases but decreases it in others.  Read more...

This script automatically splits a partitioned table, merges the partition function and then drops the associated file group for the partition.  Read more...

BI Architect Bill Pearson continues his discussion of Partition planning for Analysis Services, this time focusing on the settings and properties involved from a SQL Server Management Studio perspective.  Read more...

Read more...

Given some input parameters, it generates the filegroups, files, partition function and partition scheme sql statements.  Read more...