Cumulative Updates – SQL Server 2014 RTM CU4

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.

Author: Richie Lee

Full time computer guy, part time runner. Full time Dad, part time blogger. Knows a thing or two about Pokémon. Knows too much about SQL Agent. Writer of fractured sentences. Maker of the best damn macaroni cheese you've ever tasted.

1 thought on “Cumulative Updates – SQL Server 2014 RTM CU4”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s