As one of my KPI’s I am responsible for implementing a solution to split one of my databases in two… no problem you may think except if I tell you that one table is 100GB’s big (don’t ask I am new here). Having limited experience working with such a cumbersome amount of data I am learning things as I go. So as a first port of call I have decided to create a series of holding tables that I am going to use to hold one months worth of data, drop the original table rename the holding table, implement ......