No title

These days I am busy, I got a task to optimize the system we are maintaining.
There is a very complex view, it contains many tables, one of them has 4 million
data, so it consts several hours when the view is executed.
We thought and tried many ways,e.g. BCP and DTS, the BCP is amazing,
copy 4 million data from a text file to a table only costed 1 minute.

One month ago I will take an exam about Japanese, I am prepairing for it now,
I am not sure I can pass it, I will try my best.