Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What are the ways to improve performance of the following procedure:

Every day I take a datafile, bcp it into an intermediate table without indexes (so that data import is as fast as possible), and then move it to a second table which has a lot of complex indexes which guarantee data validity. Number of rows inserted each day is like 1 million.

Data retention on the intermediate table does not matter, so I was thinking about using in-memory table (which are unfortunately available only in 15.5) or disabling transaction log(is it possible to just 1 table?), or something else...

Any clues?

share|improve this question
up vote 0 down vote accepted

Use a (nonshareable) temporary table?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.