Data Removal, Archiving and Structure
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.
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.
Generate BCP Format Files - Dynamically generate BCP format files given the Table Name and Delimiter.
Generate Data Insert Statements - A common task with protection against special characters by using hex encoding to script out string contents.
Generate Hierarchical Table Listing - An alternative implementation of the generation of a hierarchical list of tables for use in data deletion