Bulk insert using UNICODE data files

  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 format) "test1",test2,Praha 5 – Reporyjezøíujc "test1",test2,Praha 5 – Reporyjezøíujc format.fmt (ANSI format otherwise SQL Server asks…

2

SSIS 2008 SCD wizard does not show non-SQL Server connections

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. However using advanced editor is still possible to select non-SQL OLEDB providers since mappings…

0

SQL Server checkpoint problems

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 logging you might notice:                   (…) 2008-11-13 16:10:19.57 spid13s     Ckpt dbid 5 started…

0