[dba-SQLServer] Really Interesting puzzle

Arthur Fuller fuller.artful at gmail.com
Fri Oct 3 17:41:02 CDT 2008


Interesting. Thanks for your "second pair of eyes" on this problem.
Arthur
On Fri, Oct 3, 2008 at 5:49 PM, Gustav Brock <gustav at cactus.dk> wrote:

> Hi Arthur
>
> I don't see a problem with that approach.
>
> However, no matter how fast your C++ part is, the "disk part" may be slower
> which means it takes a fraction of time to create, write and close the file;
> a chance exists that the bulk insert will start reading a file before it has
> been closed.
> This can be avoided by creating the file with another name, say
> xxx_20081103_01.tmp, and then let the C++ part rename it after it has been
> closed to .csv.
>
> /gustav
>



More information about the dba-SQLServer mailing list