SQLServerCentral.com Articles tagged Partitioning

Partitioning in SQL Server: Managing Sliding Window Scenario

Thu, 11 Apr 2013 06:00:00 UT

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?

Thu, 21 Feb 2013 07:00:00 UT

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

Partitioning in SQL Server - Part 3

Tue, 05 Feb 2013 07:00:00 UT

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

Partitioning in SQL Server

Thu, 03 Jan 2013 07:00:00 UT

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.

Support for 15,000 Partitions in SQL Server 2008 SP2 and SQL Server 2008 R2 SP1

Thu, 09 Jun 2011 06:00:00 UT

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.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

Automate Sliding Window Partition Maintenance: Part III

Tue, 28 Dec 2010 07:00:00 UT

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

Automate Sliding Window Partition Maintenance: Part II

Tue, 21 Dec 2010 07:00:00 UT

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.

Automate Sliding Window Partition Management: Part I

Tue, 14 Dec 2010 07:00:00 UT

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

Improving Performance of Cross-Partition Queries

Tue, 04 May 2010 06:00:00 UT

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

Cube Storage: Planning Partitions from a SQL Server Management Studio Perspective

Wed, 16 Dec 2009 07:00:00 UT

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.