SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Purge Rss

Search for any content tagged purge

   Items 1 to 5 of 5   
 

A General Way to Maintain History Tables

You will see here a way to handle history tables. This way only takes into account Date-based data cleanup but is easily generalizable.  Read more...
By Jefferson Elias 2017/06/30 (first published: 2015/09/28) | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 9,343 reads

Data Lifecycle Management using SQL Server

With the data proliferation issues, a well-defined lifecycle for data retention is a growing demand.  Read more...
By Joao Osorio 2016/11/10 | Source: SQLServerCentral.com | Category: ilm
Rating: |  Discuss |   Briefcase | 1,142 reads

A General Way to Maintain History Tables

You will see here a way to handle history tables. This way only takes into account Date-based data cleanup but is easily generalizable.  Read more...
By Jefferson Elias 2017/06/30 (first published: 2015/09/28) | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 9,343 reads

Deleting large number of rows from a table in a VLDB

For enterprise systems, purging data is a reality. Today, we will see some strategies that I recently implemented to make this process work efficiently.  Read more...
By Nakul Vachhrajani 2013/03/08 (first published: 2011/03/24) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 23,135 reads

Deleting large number of rows from a table in a VLDB

For enterprise systems, purging data is a reality. Today, we will see some strategies that I recently implemented to make this process work efficiently.  Read more...
By Nakul Vachhrajani 2013/03/08 (first published: 2011/03/24) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 23,135 reads
   Items 1 to 5 of 5