Did you ever tried to use bulk insert with unicode instead of ansi data files using a format file as described below: BULK INSERT MyTestTable FROM 'c:\data2.txt' WITH ( FORMATFILE = 'c:\format.fmt',DATAFILETYPE = 'widechar' ) go data2.txt (UNICODE...

This change has been implemented due a problem/limitation on non SQL OLEDB that generated invalid packages when using wizard, this problem has been reported by many customers so a new topic will be added on books online to mention this restriction. ...

On high end performance servers with a huge amount of memory you might notice some spikes on I/O activity due checkpoint executions as examplified below: On SQL Server error log after enabling trace flags 3504 and 3502 to enable checkpoint verbose...