Cool Tips‎ > ‎

Data Removal, Archiving and Structure

 

Title

Description

Applicability

 

Move text data from column to file

Extract large text columns to individual files and replace the original value with a URI for the extracted file.

 

2000, 2005, 2008, 2008R2, 2012

 

 

 

Hierarchical Data Deletion/Archiving    

Two methods of deleting data involved in PK/FK relationship.  One by disabling the constraints and the other by traversing the constraint hierarchy.

 

 

2000, 2005, 2008, 2008R2, 2012

 

Generate BCP Format Files    

 

Dynamically generate BCP format files given the Table Name and Delimiter. 

 

2000, 2005, 2008, 2008R2, 2012

 

Generate Data Insert Statements

A common task with protection against special characters by using hex encoding to script out string contents.

 

2000, 2005, 2008, 2008R2, 2012

 

Generate Hierarchical Table Listing

An alternative implementation of the generation of a hierarchical list of tables for use in data deletion

 

2000, 2005, 2008, 2008R2, 2012

 

 

 

 

 

 

 

 

 

 

 

 

Comments