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

SQL Server R Services 2016 Bug

Kevin Feasel

2018-12-28

Bugs, R

Gonzalo Bissio takes us through a bug in SQL Server R Services 2016 (which has already been fixed in 2017): 2 Weeks ago I was working in a very interesting case in SQL 2016. I received an email from one of my customers saying that they were having intermitent issues within their app that was […]

Read More

Query Store & Spinlocks

David Fowler ran into an issue with the Query Store process experiencing waits due to spinlocks: We were enjoying a nice peaceful afternoon when we hear panicked shouting that a SQL Server had become unresponsive and the customers were unable to do anything. We moseyed on down to the server in question to take a […]

Read More

Categories

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