SELECT COUNT(*) FROM tbTable01 -- 1537995
SELECT COUNT(*) FROM tbTable02 -- 0
ALTER TABLE tbTable01 SWITCH TO tbTable02;
SELECT COUNT(*) FROM tbTable01 -- 0
SELECT COUNT(*) FROM tbTable02 -- 1537995
Sources:
https://pragmaticworks.com/blog/table-partitioning-in-sql-server-partition-switching
Comments