[dba-SQLServer] Any way to help speed things up?

David McAfee davidmcafee at gmail.com
Thu May 8 11:10:32 CDT 2014


Hi all, I've been busy working at my new job with SQL related tasks.

My current project is to import a huge (120 column) table from 710
access databases spread around 14 network locations into SQL server.

I've created an SSIS package that loops through a recordset of connection
strings and database paths, importing new and changed records into a master
load table.

The SSIS package normalizes the data a bit into and places the data in
their respective locations, then truncates the load table and continues the
loop.


I've altered my Database and set the Recovery to Simple.

I run the package in batches of 10-20 mdb imports just to check things out.

I shrink the log file after every batch (which grows pretty big).

Is there any tips that can save me some time and possibly space?

Thanks in advance,
David


More information about the dba-SQLServer mailing list