SQL Server 2005 or later script to generate TRUNCATE statements for all tables ... is preferred since it just drops all data pages associated with the table, does not fire table triggers, and resets ...

When you have a clustered index the table gets physically rearranged every time you insert.<BR><BR>One of my most common moves is to insert into new table, drop old, rename new, add indexes. ••• ...