A very useful approach to clearing down data from tables . This will truncate a specific table , without it being logged. Use with caution! ALTER TABLE schema.table_name activate not logged initially with empty table
Read more →
Jack Vamvas is a Senior DBA . I work for a number of Top 100 companies specialising in managing large DB2 and SQL Server environments