January 13, 2019
Applying Data Retention to a SQL Table

There are many reasons why you’d need to delete old data from a table within a database, some of which include; # GDPR (adhering to data retention policies)# Ever increasing tables becoming tougher to manage (e.g. a replication refresh is taking 2 days)# SQL Server Express limitations (10GB max database size)# The table is storing application […]

August 30, 2018
Batch Deletions in SQL Server

This script will delete rows within a table that are out-with the specified retention period. This can be useful if you’re running deletes on large tables, and particularly if; # Deletes are taking a long time & you’re finding it difficult to track progress.# You have a short maintenance window each day to perform such […]