Bulk Insert Bug

Kevin Feasel

2016-06-09

Bugs

Cody Konior has uncovered a bug in SQL Server 2016 RTM pertaining to bulk insertion:

The bug itself is triggered by a combination of > 2000 lines of data and a lot of fields; I’ve been able to reproduce it with 2189 lines and 130 delimiters as an example which you can download here.

Here’s hoping CU1 will have that fixed.

Related Posts

Beware Multi-Assignment dplyr::mutate() Statements

Kevin Feasel

2018-01-23

Bugs, R

John Mount hits on an issue when using dplyr backed by a database in R: Notice the above gives an incorrect result: all of the x_i columns are identical, and all of the y_i columns are identical. I am not saying the above code is in any way desirable (though something like it does arise naturally in certain test […]

Read More

ML Services Can Fill The Plan Cache

Kevin Feasel

2018-01-04

Bugs, R

I have a post talking about a bug in SQL Server: For now, the workaround I have is to restart the SQL Server service occasionally. You can see that I have done it twice in the above screenshot. Our application is resilient to short database downtimes, so this isn’t a bad workaround for us; it’s […]

Read More

Categories

June 2016
MTWTFSS
« May Jul »
 12345
6789101112
13141516171819
20212223242526
27282930