We have a database which is nearly 3TB in size, out of which 8 tables together are 1.5TB which we want to partition based on year.
But as we will be partitioning over a terabyte of data, this will be very time consuming and would impact other databses/users on system.
Keeping that in mind, how should we partition the table based on date to keep processing/data movement quick.
Any suggestions on approach - means move to temp table then maybe use the
SWITCH partition function?