Smart data archiving stored procedure

This stored procedure uses a series of input parametes to generate, and optionally execute a series of SQL commands to move production data to an archive table.  The procedure assumes that the production and archive tables will have the same structure.  The procedure uses the following input parameters:@SourceTable:  This is the name of the table […]

2007-09-05 (first published: )

1,378 reads

Blogs

Azure SQL Training

By

I thought being an Azure Data/Database blogger I would share some amazing content from...

Managing virtual machine drives on ESXi

By

Recently I migrated my home lab from a SuperMicro SYS-E300-8D to something a little...

Thinking About the 2021 PASS Summit

By

I know that we don’t yet know how the 2020 Summit will turn out,...

Read the latest Blogs

Forums

Career advancement in cloud

By Aatish Patel

I am a SQL server administrator with 5 years of pure DBA experience. I...

Security for 2FA

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Security for 2FA

Basic Git for DBAs: What's a Pull Request?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Basic Git for DBAs: What's...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers