SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag Partitioning Rss

Search for any content tagged partitioning

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 6 of 6   

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 | 974 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,247 reads

Truncate Table Partition command in SQL Server

Procedure to automatically truncate table partition  
By Vidyadhar Pandekar 2014/09/29 | Source: SQLServerCentral.com | Category: truncate table
Rating: |  Discuss |   Briefcase | 9,105 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,643 reads


Given some input parameters, it generates the filegroups, files, partition function and partition scheme sql statements.  Read more...
By Pedro Lopes MS 2010/05/28 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,446 reads

Table Partitioning in SQL Server 2005

Sample script for Table Partition 
By abmore 2008/07/20 | Source: SQLServerCentral.com | Category: partition
Rating: |  Discuss |   Briefcase | 1,951 reads
   Items 1 to 6 of 6