As part of their Incremental Service Modelling, Microsoft have released SQL Server 2014 Cumulative Update #4.

To apply this cumulative update package, you must be running SQL Server 2014 RTM. So it is pertinent for versions 12.0.2000 - 12.0.2402.0.

The build number of the cumulative update package is 12.0.2430.0 . You may have to restart the computer after you apply this cumulative update package. The cumulative update package updates only those components currently installed.

This update contains 54 updates. I’m pretty much focused on CCI fixes at the moment and the one that stands out for me is:

2989704 FIX: Error 8654 when you run “INSERT INTO … SELECT” on a table with clustered columnstore index in SQL Server 2014

The summary of this fix states that it relates to when there is insufficient memory to run a bulk insert, so a non-bulk is attempted. It may still fail even if there is not enough memory to perform a non bulk insert. This fix introduces a new trace flag 9348 that helps in deciding whether or not a bulk insert is required. If the estimated number of rows is greater than 102400 than a bulk insert is used. If less than 102400 then SQL Server does not use a bulk insert. Knowing how clustered columnstore works I think 102400 is the cut off point between a row group being compressed as part of the bulk insert or just a regular row group. I’ll investigate and post findings later.