Home Forums SQL Server 2008 SQL Server 2008 - General Partitioning large tables ONLINE RE: Partitioning large tables ONLINE
MysteryJimbo
SSC-Insane
Points: 24203
More actions
September 17, 2012 at 12:58 pm
#1538780
Why?
Use the trigger on the source table to insert/update/delete in the "shadow" table.
Any additional tables and logic is adding work and complicating a simple setup