[EN] SQL Server 2014 SP1 Cumulative Update #3 is available!

LOGO__SQLServer2014Ten days ago Microsoft released two packs of packages for SQL Server 2014. Ten days give us enough time to test those packages. In this post I’m writing about update for SQL Server 2014 with Service Pack 1. In this Cumulative Update No 3 {build 12.0.4427.24} Microsoft fixed about forty bugs and here is the list of fixed KB articles:

VSTS BUG: 5618976 | 3092704
Improvements for Distribution Agent telemetry for Azure subscribers are available in SQL Server 2014
SQL service

VSTS BUG: 5666744 | 3094865
FIX: “The process could not initialize ”” error occurs when you use merge publication in SQL Server 2014
SQL service

VSTS BUG: 5704512 | 3096617
FIX: Can’t backup in-memory OLTP database that is restored by using full and differential restore in SQL Server 2014
In-Memory OLTP

VSTS BUG: 5575649 | 3097073
FIX: CPU usage is higher than expected when you reduce the value of CAP_CPU_PERCENT argument in creating resource pool
SQL service

VSTS BUG: 5544313 | 3097970
FIX: Sp_describe_undeclared_parameters returns incorrect result when undeclared parameter targets a decimal column
SQL service

VSTS BUG: 5181922  | 3068359
FIX: “Cannot find the OLAP cube Model” error when you update the pivot table in a SharePoint document in SQL Server 2012 or SQL Server 2014
Analysis Services

VSTS BUG: 5181941 | 3066299
FIX: Non-English items display in the MDS Explorer when you set language settings for web browser to English
Master Data Services (MDS)

VSTS BUG: 5715080 | 3087114
FIX: PowerPivot for SharePoint doesn’t run automatic data refresh on the first day of each month
Analysis Services

VSTS BUG: 5715082 | 3088307
FIX: Scheduler deadlock on primary replica when you remove a replica from an AlwaysOn availability group in SQL Server 2012 or SQL Server 2014
High Availability

VSTS BUG: 5715087 | 3077273
FIX: Rare incorrect result occurs when you run parallel query in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5715090 | 3080209
FIX: Error 602 when you run a stored procedure repeatedly in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS BUG: 5715112 | 3080856
FIX: Information disclosure when you create a session cube by using dynamic role-based security in SQL Server 2012 or SQL Server 2014
Analysis Services

VSTS BUG: 5715123 | 3089687
FIX: Can’t export empty Tablix header in CSV file when NoHeader is false in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG: 5715131 | 3087872
FIX: Access violations when you use the FileTable feature in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5715193  | 3097114
FIX: Queries take longer time to compile in SQL Server 2014 than in earlier versions
SQL performance

VSTS BUG: 4745298 | 3035737
FIX: SSAS instance crashes when cube writeback commit transaction and processing batch are executed at the same time
Analysis Services

VSTS BUG: 5489704 | 3099487
FIX: 100% CPU usage occurs when in-memory OLTP database is in recovery state in SQL Server 2014
In-Memory OLTP

VSTS BUG: 5687518 | 3095958
FIX: Metadata inconsistency error occurs after you switch table partitions and drop corresponding files and filegroups
SQL service

VSTS BUG: 5808923 | 3099323
FIX: DBCC CHECKFILEGROUP reports false inconsistency errors on database that has partitioned table in SQL Server 2014
SQL service

VSTS BUG: 5667070 | 3096400
FIX: It takes longer to run the ALTER DATABASE SET HADR OFF command on a secondary replica in SQL Server 2014
High Availability

VSTS BUG: 5181949 | 3075669
FIX: SSAS 2012 or SSAS 2014 crashes when you execute an MDX query that contains lots of Union expressions
Analysis Services

VSTS BUG: 5181961 | 3073530
FIX: Access Violation error occurs when you run DDL SQL statements on a database in an instance of SQL Server 2012 or SQL Server 2014
Analysis Services

VSTS BUG: 5181966 | 3073907
FIX: SSIS 2012 or SSIS 2014 package with an Execute SQL Task may stop responding
Analysis Services

VSTS BUG: 5715073 | 3095156
FIX: Error 9002 and error 3052 when you try to add or back up log file in SQL Server 2012 or SQL Server 2014
High Availability

VSTS BUG: 5715100 | 3081580
FIX: “String or binary data would be truncated” error when you use peer-to-peer replication in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5715108 | 3087094
FIX: It takes longer than expected when you run a query with non-admin user role in SSAS 2012 or SSAS 2014 in Tabular model
Analysis Services

VSTS BUG: 5715110 | 3088480
FIX: Sort operator spills to tempdb in SQL Server 2012 or SQL Server 2014 when estimated number of rows and row size are correct
SQL performance

VSTS BUG: 5522017 | 2682488
FIX: Backup operation fails in a SQL Server database after you enable change tracking
SQL service

VSTS BUG: 5536023 | 3090141
FIX: Offline checkpoint thread shuts down without providing detailed exception information in SQL Server 2014
In-Memory OLTP

VSTS BUG: 5523582 | 3072814
FIX: Access violation occurs when you connect to an instance of SQL Server by using sqlcmd utility in SQL Server 2014
SQL connectivity

VSTS BUG: 5523590 | 3080155
FIX: Rare index corruption when you build a columnstore index with parallelism on a partitioned table in SQL Server 2014
SQL service

VSTS BUG: 5523599 | 3082860
FIX: Access violation occurs when you execute a query that contains many joins and coalesce functions in SQL Server 2014
SQL performance

VSTS BUG: 5523600 | 3082005
FIX: Case-sensitive does not work in MDS database in SQL Server 2014
MDS

VSTS BUG: 5715102 | 3091643
FIX: Error occurs when you configure SQL Server replication or set up a linked server in SQL Server 2012 or SQL Server 2014
SQL security

VSTS BUG: 5829179 | 3100361
FIX: DBCC CHECKDB doesn’t report metadata inconsistency of invalid filegroups in its summary in SQL Server 2014
SQL service

VSTS BUG: 5038265 | 3092702
FIX: It takes a longer time than earlier versions of SQL Server when you run DBCC CHECKDB in SQL Server 2012
SQL service

 

This update could be applied Microsoft SQL Server 2014, when used applies to

  • Microsoft SQL Server 2014 Service Pack 1

 

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 3

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

    SQL Server 2014|MS_SQL14_SP1_QFE_CU3_x64
    SQL Server 2014|SQL_AS_OLEDB_64
    SQL Server 2014|MS_SQL14_SP1_QFE_CU3_x86
    SQL Server 2014|SQL_AS_OLEDB_86

Enjoy!

[EN] SQL Server 2012 SP2 Cumulative Update #3 is available!

LOGO__SQLServer2012SP2At the outtage of Azure time Microsoft released two packs wit Cumulative Updates. Both for Microsoft SQL Server 2012 but for different versions. In this post I’ll write about update for SQL Server 2012 with Service Pack 2. In this Cumulative Update No 3 {build no 11.0.5556.0 } Microsoft fixed about forty bugs and here is the list. As you see the links are in different place than on my all previous posts. Beginning of this update, Microsoft SQL Server Service Team (which is responsible for publishing those informations) added link fo description of fixed bug instead of KB number. A little strange, but I don’t want to spend too much time for reformating all structure.

 

VSTS BUG: 3260585 | KB: 2973961
FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server
SQL service

VSTS BUG: 3260585 | KB: 2973961
FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server
SQL service

VSTS BUG: 3260587 | KB: 2975743
FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS
Analysis Services

VSTS BUG: 2785223 | KB: 2981424
FIX: Exception when you select more than one hierarchy from parent/child dimension with naming template in SSAS 2012
Analysis Services

VSTS BUG: 3336132 | KB: 2982019
FIX: Error when you restart the Merge Agent after you upgrade the Publisher to SQL Server 2012 SP2
SQL service

VSTS BUG: 3260583 | KB: 2982544
FIX: Slow to access "Explorer" or "System Administration" on MDM home page
Data Quality Services (DQS)

VSTS BUG: 3260593 | KB: 2986722
FIX: Error 7105 when you execute UPDATE on sparse column set while ONLINE INDEX REBUILD is running on the same table in SQL Server
SQL performance

VSTS BUG: 3260595 | KB: 2987935
FIX: Long wait on CLR_CRST when you execute spatial query that is under heavy load in SQL Server
SQL service

VSTS BUG: 3260589 | KB: 2988667
FIX: Query results keep unchanged when filter is applied in a parent-child dimension with unary operators in SSAS 2012
Analysis Services

VSTS BUG: 3260581 | KB: 2989043
FIX: Access denied when you view report history on a SharePoint site with the View Items permission
Reporting Services

VSTS BUG: 2921742 | KB: 2989478
FIX: Poor performance for cdc.fn_cdc_get_net_changes_<capture_instance> in SQL Server 2012 SP2
SQL performance

VSTS BUG: 3260577 | KB: 2989512
FIX: MDX query returns no result when the cache is not cleared after you run a previous query in OLAP or tabular model
Analysis Services

VSTS BUG: 3260599 | KB: 2990152
FIX: Unexpected Simplified Chinese characters appear in TextData field of Distributed Replay trace in SQL Server
Management Tools

VSTS BUG: 3260575 | KB: 2994993
FIX: Text in a hyperlink in its own paragraph is not indexed in full-text in SQL Server 2012
SQL service

VSTS BUG: 3008500 | KB: 2995211
FIX: Incorrect error when you set rotation of chart series label greater than 90 or less than -90 in an SSRS 2012 report
Reporting Services

VSTS BUG: 3075681 | KB: 2995622
FIX: "Specified cast is not valid" error when you load an XML document that has time zone information in SSIS 2012
Integration Services

VSTS BUG: 3122214 | KB: 2996729
FIX: "Non-yielding Scheduler" condition occurs when you run a complex query in SQL Server 2012
SQL performance

VSTS BUG: 3134680 | KB: 2997392
FIX: INSERT performance decreases in merge replication that uses precomputed partitions in SQL Server 2012
SQL service

VSTS BUG: 3140832 | KB: 3000562
FIX: ImageConsolidation device information setting does not work when it is specified in the RSReportServer.config file
Reporting Services

VSTS BUG: 3203999 | KB: 3000835
FIX: "An internal error occurred on the report server" error when you export a report to a .pdf file in SSRS 2012
Reporting Services

VSTS BUG: 3187734 | KB: 3001713
FIX: The .csv file contains field separators when you export a report that has a tablix that has no data in SSRS 2012
Reporting Services

VSTS BUG: 3256393 | KB: 3002071
FIX: "System objects could not be updated…" error when you use AlwaysOn Availability Groups feature in SQL Server 2012
High Availability

VSTS BUG: 3277704 | KB: 3002883
FIX: Error in OpenFileStream API when you open FILESTREAM data that is hosted on dynamic disks in SQL Server 2012
SQL service

VSTS BUG: 3252239 | KB: 3003102
FIX: The date value in the Last Run column is blank in Report Manager Details View in SSRS 2012
Reporting Services

VSTS BUG: 3306817 | KB: 3004355
FIX: SQL Server crashes when you retrieve an SQL statement hash for logging XEvent in SQL Server 2012
SQL service

VSTS BUG: 3331484 | KB: 3006648
FIX: Data corruption occurs in target table when you use a SQL Server destination in a data flow component in SSIS 2012
SQL service

VSTS BUG: 3401421 | KB: 3008135
FIX: Abbreviations for million, billion, and others are translated incorrectly in Swedish or Italian Power View report
SQL service

VSTS BUG: 3406283 | KB: 3008416
FIX: Duplicate records in the report rendering when you use Lookup function in the expression of a matrix in SSRS 2012
Reporting Services

VSTS BUG: 3443909 | KB: 3009576
FIX: Cannot restore database by using the full backup and differential backup files that contain defunct files
SQL service

VSTS BUG: 3449716 | KB: 3009883
FIX: Error when you execute statistics update on a table that has sql_variant data type in SQL Server 2012
SQL performance

VSTS BUG: 3389698 | KB: 3010773
FIX: Power View report plots values incorrectly for line chart in SSRS 2012 in SharePoint integrated mode
SQL service

VSTS BUG: 3266265 | KB: 3011807
FIX: Large chain of blocking occurs when you use merge replication in SQL Server 2012
SQL service

VSTS BUG: 3343220 | KB: 3012182
FIX: Log_Send_Rate column in sys.dm_hadr_database_replica_states cannot reflect the rate accurately in SQL Server 2012
High Availability

VSTS BUG: 3012389 | KB: 3013553
FIX: Insufficient memory error when you run an XML Validation Control Flow task on a large input file in SSIS 2012
SQL service

 

This update could be applied to Microsoft SQL Server 2012 Service Pack 2, when used with:

  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
  • SQL Server 2012 Reporting Services
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence

     

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 3

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP:

  1. Install the service pack on the passive node.
  2. Install the service pack on the active node (This step requests servicerestart).

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

>> SQLServer2012_SP2_CU3_3002049_11_0_5556_x64
>> SQLServer2012_SP2_CU3_3002049_11_0_5556_x86

Enjoy!

[EN] SQL Server 2014 Cumulative Update #3 is available!

LOGO__SQLServer2014downloadFew days ago Microsoft released newest package of updates for SQL Server 2014. In this Cumulative Update No 3 (buil number 12.0.2402.0) Microsoft resolved about thirty bugs. Here is the list:

 

VSTS BUG:  2556594 | 2936984
FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL Server
SQL service

VSTS BUG: 2714497 | 2952444
FIX: Poor performance when you use table variables in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS BUG: 2578278 | 2954861
FIX: "Query Timeout Expired" when you preview a command of an SSIS package in SSDT
Integration Services

VSTS BUG: 2578282 | 2957768
FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG: 2578276 | 2957957
FIX: Attributes sort incorrectly after you use the Attribute Properties function in SQL Server MDS Add-in for Excel
Data Quality Services (DQS)

VSTS BUG: 2578288 | 2959342
FIX: Data-driven subscription can’t be created when the driving query takes longer than 30 seconds to execute in SQL Server
Reporting Services

VSTS BUG: 2319134 | 2960924
FIX: Cannot open the memory-optimized table template remotely in SQL Server 2014
Management Tools

VSTS BUG: 2578302 | 2961559
FIX: Incorrect folder when deploying SQL Server 2012 or SQL Server 2014 PowerPivot solutions by using SharePoint 2013 Central Admin
Analysis Services

VSTS BUG: 2578304 | 2963372
FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 2823096 | 2963386
FIX: SSRS 2012 or SSRS 2014 fails with IsolatedStorageException when subscriptions exported to Excel worksheets are larger than 10 MB
Reporting Services

VSTS BUG: 2782748 | 2963668
FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitions
SQL service

VSTS BUG: 2578285 | 2963836
FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG: 2525292 | 2967635
FIX: Incorrect DBA reference of business rules after you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDS or SQL Server 2014 MDS
DQS

VSTS BUG: 2504388 | 2968418
FIX: "Non-yielding scheduler" error when you insert or update many rows in one transaction in SQL Server 2014
In-Memory OLTP

VSTS BUG: 2906109 | 2968909
FIX:Access violation when you query sys.extended_properties table in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 2906113 | 2973561
FIX: Error when you insert a record into a FileTable or FILESTREAM in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 2906095 | 2975322
FIX: Blank value is set to NULL value in a business rule in MDS of SQL Server 2012 or SQL Server 2014
DQS

VSTS BUG: 2906139 | 2975402
FIX: Log Reader Agent crashes during initialization when you use transactional replication in SQL Server
SQL service

VSTS BUG: 2515653 | 2975434
FIX: Error when you complete an SSAS 2014 image after specifying a non-default root directory
Analysis Services

VSTS BUG: 2782757 | 2977312
FIX: Incorrect result when you use LIKE pattern to match the Japanese repeat character (Cho-On) in SQL Server
SQL service

VSTS BUG: 2906893 | 2978472
FIX: UPDATE or INSERT statement on CCI makes sys.partitions not match actual row count in SQL Server 2014
SQL service

VSTS BUG: 2906137 | 2979121
FIX: Log Reader Agent fails when you upgrade from SQL Server 2008 to SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 2906141 | 2979587
FIX: Image completion setup fails when you use SysPrep to install localized version of SQL Server
Setup & Install

VSTS BUG: 2789872 | 2981764
FIX: Cannot create indexed view on a clustered columnstore index and BCP on the table fails in SQL Server 2014
SQL service

VSTS BUG: 2796999 | 2984628
FIX: Auto-statistics creation increases the compilation time for natively compiled stored procedure in SQL Server 2014
In-Memory OLTP

VSTS BUG: 2797130 | 2984629
FIX: LCK_M_SCH_M occurs when you access memory-optimized table variables outside natively compiled stored procedures
In-Memory OLTP

VSTS BUG: 2531271 | 2984907
FIX: "The current SQL Server edition is not supported by MDS" error when you browse to the MDS website
DQS

VSTS BUG: 2704551 | 2986081
FIX: An access violation occurs when you use UPDATE STATISTICS on a computed column in SQL Server 2014
SQL performance

VSTS BUG: 2828009 | 2988552
FIX: Update enables SQLDOM to support "service_objective" in the Microsoft Azure SQL Database
SQL service

VSTS BUG: 2718825 | 2989704
FIX: Some columns in sys.column_store_segments view show NULL value when the table has non-dbo schema in SQL Server 2014
SQL service

VSTS BUG: 2895169 | 2989715
FIX: Dimension attribute is lost in Excel PivotTable Field List when you set AttributeHierarchyDisplayFolder to "\" in SSDT-BI
Analysis Services

 

This update could be applied to Microsoft SQL Server 2014, when used with:

  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Standard
  • Microsoft SQL Server 2014 Web
  • SQL Server 2014 Reporting Services
  • Microsoft SQL Server 2014 Business Intelligence

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 3

You may have to restart the computer after you apply this cumulative update.

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages (size for x64bit platform is around 609 MB):

>> SQLServer2014_RTM_CU3_2984923_12_0_2402_x64
>> SQLServer2014_RTM_CU3_2984923_12_0_2402_x86

Enjoy!