I created a copy of the database on the remote server and generated a SQL script to TRUNCATE all the tables in the copy database as shown in Listing 1. After a quick backup of the newly cleaned ...

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. ••• ...