Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: | Category: partitioning
Rating: |  Discuss |   Briefcase | 896 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: | Category: partitioning
Rating: (not yet rated) |  Discuss |   Briefcase | 1,211 reads

Truncate Table Partition command in SQL Server

Procedure to automatically truncate table partition  
By Vidyadhar Pandekar 2014/09/29 | Source: | Category: truncate table
Rating: |  Discuss |   Briefcase | 8,258 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: | Category: powershell
Rating: |  Discuss |   Briefcase | 1,539 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: | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,423 reads

Table Partitioning in SQL Server 2005

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