Partition Management Release 2.0

Rating:        Based on 3 ratings
Reviewed:  2 reviews
Downloads: 13044
Released: Feb 23, 2009
Updated: Feb 23, 2009 by Stuarto
Dev status: Stable Help Icon

Recommended Download

Documentation Readme
documentation, 52K, uploaded Feb 23, 2009 - 7293 downloads

Other Available Downloads

Application ManagePartition.exe
application, 27K, uploaded Feb 23, 2009 - 2907 downloads
Source Code
source code, 72K, uploaded Feb 23, 2009 - 2844 downloads

Release Notes

Release 2.0 adds support for SQL Server 2008, but is also fully compatible with SQL Server 2005.
The release consists of:
• A Readme file
• The Executable
• The source code (Visual Studio project)

This release is designed and tested to work with SQL Server 2005, Service Pack 1 or later.

Enhancements from V1 include:
  • Support for automatically handling partition-aligned indexed views in SQL Server 2008
  • Handles sparse columns and filtered indexes in SQL Server 2008
  • Accommodates the new date and time data types in SQL Server 2008
  • Clustered index is always created first
  • New command “CreateStagingClusteredIndex” supports creating only the Clustered Index to optimize a load of presorted data; additional indexes can be automatically built later using “IndexStaging”
  • Support for Nullable partitioning keys
  • Support for compressed tables and indexes in SQL Server 2008
  • Default constraints are inherited from the partitioned table to assist with data loading into staging tables
  • Connection Timeout eliminated

Test scripts for both SQL Server 2005 and SQL Server 2008 are included in the Visual Studio project. To modify or compile the source code, please use Visual Studio 2008 SP1 or later.

Reviews for this release

Works nicely, Has issues if your not using US date formats though. See the issue I raised for solution.
by WeeeBob on Jan 22, 2010 at 4:11 PM
This application does exactly what it says. Once you learn how to use it, it makes building staging tables easy for switching partitions.
by mufford on Oct 9, 2009 at 4:33 PM