Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Partitioning Rss

   Items 1 to 20 of 27    Older >>
 

Partitioning Data in a Multi-tenant Data Warehouse Solution

Part two of our series looks at the partitioning strategy to separate customers' data, providing security and performance.  Read more...
By Sean Woehrle 2014/04/22 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 3,260 reads

Partitioned Table View

This is my View for collecting information about partitioned tables.  Read more...
By Eric Eyster 2014/03/26 | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 663 reads

Automate Sliding Window Partition Maintenance: Part III

Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell  Read more...
By Hugh Scott 2014/03/21 (first published: 2010/12/28) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 5,874 reads

Automate Sliding Window Partition Maintenance: Part II

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...
By Hugh Scott 2014/03/14 (first published: 2010/12/21) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 7,637 reads

Automate Sliding Window Partition Management: Part I

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...
By Hugh Scott 2014/03/07 (first published: 2010/12/14) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 13,619 reads

SQL Server 2012 Analysis Services Partitioning Performance Demonstration

How much of an improvement in processing time can a simple SQL Server Analysis Services (SSAS) partitioning structure provide? Can you provide any examples? Does this processing time improvement only apply to the fact tables? Check out this tip to learn more.  Read more...
By Additional Articles 2013/08/19 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 3,083 reads

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.  Read more...
By Additional Articles 2013/04/11 | Source: Database Journal | Category: partitioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,084 reads

Filtered Indexes - Simple Partitioning without Enterprise Edition?

This article discusses using Filtered Indexes as a simple partitioning strategy in SQL Server Standard Edition  Read more...
By Nigel Maneffa 2013/02/21 | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 5,977 reads

Partitioning in SQL Server - Part 3

Arshad Ali provides a step-by-step guide to create a partitioned table/index.  Read more...
By Additional Articles 2013/02/05 | Source: Database Journal | Category: partitioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,620 reads

Example of SQL Server table partitioning

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...
By kleegeek 2013/01/18 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,919 reads

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.  Read more...
By Additional Articles 2013/01/03 | Source: Database Journal | Category: partitioning
Rating: (not yet rated)  Rate this |   Briefcase | 4,355 reads

Partitioned index

By Igor Micev 2012/11/02 | Category: partitioning
Rating: (not yet rated) |  Discuss |   Briefcase | 2,550 reads

SQL Partition

By Srikanth Soundararajan 2011/09/16 | Category: partitioning
Rating: (not yet rated) |  Discuss |   Briefcase | 2,072 reads

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

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...
By Additional Articles 2011/06/09 | Source: TechNet Blogs | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 2,168 reads

View all table and index partition

This view shows range limits, number of rows and filegroup for each partition for each table  Read more...
By Federico Iori 2011/05/09 | Source: SQLServerCentral.com | Category: partitioning
Rating: (not yet rated) |  Discuss |   Briefcase | 1,180 reads

Automate Sliding Window Partition Maintenance: Part III

Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell  Read more...
By Hugh Scott 2014/03/21 (first published: 2010/12/28) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 5,874 reads

Automate Sliding Window Partition Maintenance: Part II

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...
By Hugh Scott 2014/03/14 (first published: 2010/12/21) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 7,637 reads

Automate Sliding Window Partition Management: Part I

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...
By Hugh Scott 2014/03/07 (first published: 2010/12/14) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 13,619 reads

Automate Range Right Partition Management with PowerShell

This script automatically splits a partitioned table, merges the partition function and then drops the associated file group for the partition.  Read more...
By Hugh Scott 2010/11/11 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,464 reads

Automate Range Right Partition Management with PowerShell

This script automatically splits a partitioned table, merges the partition function and then drops the associated file group for the partition.  Read more...
By Hugh Scott 2010/11/11 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,464 reads
   Items 1 to 20 of 27    Older >>
 
Tags
administration (3)    
powershell (3)    
partition (2)    
sliding windows (2)    
analysis services (ssas) (1)    
blogs (1)    
business intelligence (1)    
data warehousing (1)    
filtered indexes (1)    
multi-tenant (1)    
performance tuning (1)    
sliding windows technique (1)    
sql server 2005 (1)    
sql server 2008 (1)    
ssas (1)    
table partitioning (1)    
views (1)