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

Add a script

   Items 1 to 4 of 4   
 

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,113 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,367 reads

usp_PartitionDatabase

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,380 reads

Table Partitioning in SQL Server 2005

Sample script for Table Partition  Read more...
By abmore 2013/05/24 | Source: SQLServerCentral.com | Category: partition
Rating: |  Discuss |   Briefcase | 1,801 reads
   Items 1 to 4 of 4