0
I Use This!
Activity Not Available

Project Summary

The general problems addressed by this utility are:
1. Guaranteeing that the staging table required to SWITCH in or out a partition is always created correctly ‘just in time’, with the right indexes, columns, foreign keys, and partition-specific check constraint and filegroup corresponding to the target partition of a partitioned table.
2. Ensuring that any partition management scripts stay in synch with the possible index changes or foreign key constraints of partition tables over time. Without this utility, any change to a partition table’s DDL would require an equivalent change in a TSQL-based partition management script, along with associated testing, etc.
3. Providing an easy mechanism to quickly empty a selected partition from a partitioned table with a single command-line 4. Allowing fine-tuned partition data loading – including scenarios in which you want to create a staging table and populate it, and create indexes later prior to a SWITCH in operation.

The utility must be run from the command line or within an SSIS package. Command line parameters determine behavior. You may perform one of four different functions depending on the COMMAND parameter. Additional parameters define the connection (server, integrated security, etc); database, schema, partitioned table name, etc. You have the option of identifying a partition to manage either by explicit partition number (/p:) OR by specifying a string representation of a value that can be input to the partition range function to determine a partition number (/v:).

Tags

2005 database server sql vldb

In a Nutshell, SQL Server 2005 Partition Management...

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

This Project has No vulnerabilities Reported Against it

Did You Know...

  • ...
    55% of companies leverage OSS for production infrastructure
  • ...
    by exploring contributors within projects, you can view details on every commit they have made to that project
  • ...
    there are over 3,000 projects on the Open Hub with security vulnerabilities reported against them
  • ...
    anyone with an Open Hub account can update a project's tags

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

Community Rating

Be the first to rate this project
Click to add your rating
   Spinner
Review this Project!
Sample ohloh analysis