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

Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server ... You might want to truncate the existing table before you import the new data ...

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