Home > Hotfix > Hotfixes for SQL Server 2014 RTM – Cumulative Update 2

Hotfixes for SQL Server 2014 RTM – Cumulative Update 2

Microsoft released Cumulative Update 2 for SQL Server 2014 RTM. This blog post contains hot-fix details for BI (SSIS, DQS, SSAS, SSRS), In-Memeory OLTP, SQL Server Performance topics.

Integration Services

  1. FIX: The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012 or SSIS 2014
  2. FIX: Errors when you use export/import data wizard to move data in SQL Server
  3. FIX: The execution of an SSIS package that is stored in MSDB is slower than it is stored on the file system
  4. FIX: SSIS 2012 or SSIS 2014 XML validator only outputs “TRUE” or “FALSE” when you perform XML validation
  5. FIX: Error when you add a custom connection manager in SSIS 2014 Designer

Data Quality Services (DQS)

  1. FIX: Error when you execute DQS stored procedure [internal_core].[RestoreDQDatabases] in SQL Server
  2. FIX: Error when you use DQS Cleansing component with large batch in an SSIS 2012 or SSIS 2014 package

Analysis Services

  1. FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012 or SSAS 2014
  2. FIX: SSAS instance crashes when you perform writeback action by using the role with cell security defined
  3. FIX: The execution of an MDX query in SSAS 2012 or SSAS 2014 is much slower than it is in SSAS 2008 R2
  4. FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012 or SSAS 2014
  5. FIX: Data models do not load after you run a PowerPivot scheduled data refresh job when you work with SQL Server 2014
  6. FIX: You cannot create a power view report against a UDM cube in SSAS 2014
  7. FIX: Poor performance when you use DAX functions on a String or Boolean column in SSAS 2014
  8. Can now disable checking whether dimension and partition data originate from the same data source when you run a ROLAP query in SQL Server 2014

Reporting Services

  1. FIX: “SQL Server performance counters are disabled” when you move the SQL Server resource in SQL Server 2014

In-Memory OLTP

  1. FIX: Error in checking master database after you bind a memory-optimized database to a resource pool in SQL Server 2014
  2. FIX: Sys.indexes returns incorrect value for indexes in SQL Server 2014

SQL performance

  1. FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server
  2. FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server
  3. FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL Server
  4. FIX: An access violation occurs when you execute update query on a table that has a DML trigger in SQL Server
  5. FIX: Poor cardinality estimation when the ascending key column is branded as stationary in SQL Server
  6. FIX: Metadata corruption occurs when you update index statistics with INCREMENTAL=ON in SQL Server 2014

Download now

Categories: Hotfix Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: