can anyone help? tp sum up, i have a number of tables that clear the data (delete * from table) then import from an odbc table. Thios happens every 5...

also if i run a query over these databases it takes longer as they're large in size, even though they don't have a large row count. In test i've created...

what happens each time the job runs is it deletes all in the table (Delete * from table) then it loads in from the odbc to the table in sql....

just ran a report so show disk usage by table, you can see very few rows but as they keep updating, the size seems to grow

Hi, the tables are updated using SSIS package basically what happens is an sql command runs (delete from table) then a connection to an external odbc dbase (Select * from...