Skip to main content

Posts

Showing posts from September, 2013

Cloning SQL tables

Plenty of folks have blogged about various techniques for cloning tables in SQL server, and for good reason... during data loading and data processing its very useful to be able to build one table while simultaneously reporting off of another. When the processing of the new table is completed, it can be switched in to replace the data of the old table.

To simplify the creation of a build table, I've written a stored procedure which will take any table and clone it and its indexes: