[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 #8 is available!

Newest update for SQL Server 2012. This time for SQL Server 2012 with Service Pack 2. In this Cumulative Update No 8 {build 11.0.5634.1} Microsoft released over twenty four bugs and issues. Here is the list of fixed issues:

VSTS BUG: 5020090 | 3081074
FIX: A stalled dispatcher system dump forces a failover and service outage in SQL Server 2014 or SQL Server 2012
High Availability

VSTS BUG: 4812002 | 3082877
FIX: No error is prompted when connection is terminated in sqlcmd
SQL service

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

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

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

VSTS BUG: 5469866 | 3087920
FIX: Excel crashes when you use Excel 2010 on a computer that has the .NET Framework 4.6 installed
Analysis Services

VSTS BUG: 5153046 | 3088480
FIX: Data spill occurs when you sort large amount of data in SQL Server 2012
SQL performance

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

VSTS BUG: 5173142 | 3081150
FIX: Orientation setting is lost when you export a report to a Word document in SSRS 2012
Reporting Services

VSTS BUG: 5510259 | 3089527
FIX: FileStream Share Access fails when you use AlwaysOn Availability Groups feature in SQL Server 2012
High Availability

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

VSTS BUG: 5067331 | 3090049
FIX: Transparent Data Encryption certificate can’t be created in SQL Server 2012
SQL security

VSTS BUG: 4259067 | 3054180
FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2014 SP1
SQL service

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

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

VSTS BUG: 5174510 | 3092703
FIX: Access violation occurs in AlwaysOn availability groups scenarios in SQL Server 2012
SQL performance

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

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

VSTS BUG: 5586474 | 3074434
FIX: Out of memory error when the virtual address space of the SQL Server process is very low on available memory
SQL service

VSTS BUG: 5502135 | 3093869
FIX: SQLDiag fails with function 87 error in SQL AlwaysOn scenario where the server name has 15 characters
Management Tools

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

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

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

 

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

  • Microsoft SQL Server 2012 Service Pack 2

 

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 8

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 2012 | ql11Sp2Cu8x64
    SQL Server 2012 | Sql11Sp2Cu8x86

Enjoy!

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

LOGO__SQLServer2014downloadTwo weeks ago Microsoft released two new packages with cumulative updates. In my secnd post I writing about Cumulative Update No 2 {build 12.0.4422.0} for SQL Server 2014 with Service Pack 1 release. In this package Microsoft fixed almost fifty bugs and here is the list:

VSTSBUG: 4814178 | 3088041
FIX: 401 error occurs when you try to connect to an MDS solution by using MDS Add-in for Excel
MDS

VSTSBUG: 5181962 | 3074535
FIX: The Resource database is missing after you install updates or service packs for instances of SQL Server 2012 one after another and then restart the server
SQL service

VSTSBUG: 5181906 | 972759
FIX: Installing SQL Server 2008 Service Pack 1 may reset the “max_worker_threads” column value for a SQL Server Agent subsystem
Management Tools

VSTSBUG: 4812206 | 3082885
FIX: Cannot find file error occurs when you execute a maintenance plan to back up database in SQL Server 2014
SQL service

VSTSBUG: 5181968 | 3075176
FIX: Incorrect results from the CHANGETABLE() function when snapshot isolation is enabled for a SQL Server 2012 or 2014 database
SQL service

VSTSBUG: 5181959 | 2820068
Can’t install SQL Server by using InstallShield or bootstrapping application
Setup & Install

VSTSBUG: 5181957 | 3069320
FIX: A workflow never starts in a SharePoint 2013 environment when you use SQL Server 2012 or 2014 Master Data Services to start the workflow
Data Quality Services (DQS)

VSTSBUG: 5181924 | 3074922
FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012 or SQL Server 2014
SQL performance

VSTSBUG: 5181916 | 3074425
FIX: CMEMTHREAD waits occur when you execute many ad hoc queries in SQL Server 2012 or SQL Server 2014
SQL service

VSTSBUG: 5181914 | 3069154
FIX: You cannot set a SQL Server 2012 or 2014 database to single-user mode if the database is read-only
SQL service

VSTSBUG: 5181908 | 3076444
FIX: Cannot enable “change data capture” on a table that uses a unique index with more than one included column in SQL Server 2012 or 2014
SQL service

VSTSBUG: 4772921 | 3036330
FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005
Management Tools

VSTSBUG: 5181952 | 3068703
FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012 or 2014
SQL service

VSTSBUG: 5196810 | 3083187
FIX: “Requested value was not found” error when you deploy a SQL Server 2014 database to Windows Azure
Management Tools

VSTSBUG: 5036505 | 3081758
FIX: Can’t view the properties of a contained database in Object Explorer in SQL Server 2014 SP1
Management Tools

VSTSBUG: 4921466 | 3075850
FIX: Error 1635 occurs when you use Product Update to install SQL Server 2014 SP1 and SQL Server 2014 SP1 CU1
Setup & Install

VSTSBUG: 4776005 | 2987585
Restore Log with Standby Mode on an Advanced Format disk may cause a 9004 error in SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTSBUG: 4745317 | 3047538
FIX: Result of aggregated values is incorrect when you execute an MDX query in SSAS 2012 or SSAS 2014
Analysis Services

VSTSBUG: 4745296 | 3033456
FIX: Poor performance when you run an MDX query that contains a sub-select of different granularities in SSAS 2012
Analysis Services

VSTSBUG: 4737005 | 3016384
FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012 or SSAS 2014
Analysis Services

VSTSBUG: 4736989 | 3010148
FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS
Analysis Services

VSTSBUG: 4736988 | 3006838
FIX: Instance of SSAS 2012 or SSAS 2014 crashes when cube writeback commit and processing transactions are executed at the same time
Analysis Services

VSTSBUG: 4584562 | 3029776
FIX: Memory consumption increases quickly and surpasses HardMemoryLimit when you run a query in Many-To-Many dimension
Analysis Services

VSTSBUG: 5159952 | 3081291
FIX: Increased HADR_SYNC_COMMIT wait types when AlwaysOn Availability Groups contain memory-optimized tables in SQL Server 2014 Service Pack 1
High Availability

VSTSBUG: 5020141 | 3081074
FIX: A stalled dispatcher system dump occurs forcing a failover and service outage on the availability groups in SQL Server 2014 Service Pack 1
High Availability

VSTSBUG: 5181955 | 3068776
FIX: Incorrect results occur in a rare scenario when you run a query that contains a nested loop join and performance spool in its inner side in SQL Server 2012 or 2014
SQL performance

VSTSBUG: 5181937 | 2965654
FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer
Reporting Services

VSTSBUG: 5181930 | 3064292
FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll in SQL Server 2012 or SQL Server 2014
SQL service

VSTSBUG: 4867179 | 3071617
FIX: “Cannot Start Application” error occurs when you start SQL Server Reporting Services Report Builder in SQL Server 2014 Service Pack 1
Reporting Services

VSTSBUG: 4741577 | 3028216
FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012 or SSAS 2014
Analysis Services

VSTSBUG: 4741535 | 3025408
FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS 2012 or SSAS 2014
Analysis Services

VSTSBUG: 4737114 | 3029126
FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 or SSAS 2014 multidimensional cube
Analysis Services

VSTSBUG: 4737059 | 3017544
FIX: SSAS 2012 or SSAS 2014 crashes when a writeback commit transaction and batch processing are executed concurrently
Analysis Services

VSTSBUG: 4584553 | 3042077
FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012 or SSAS 2014
Analysis Services

VSTSBUG: 4584517 | 3051798
FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services
Analysis Services

VSTSBUG: 4744189 | 3054504
FIX: The bcp utility may crash when you use SQL Server 2012 or SQL Server 2014
SQL connectivity

VSTSBUG: 4767653 | 3057876
FIX: An AlwaysOn database on a secondary replica shows a “NOT SYNCHRONIZING” status in SQL Server 2014
High Availability

VSTSBUG: 4921039 | 3073294
FIX: “Possible schema corruption. Run DBCC CHECKCATALOG” error occurs when you delete column in SQL Server 2014
SQL service

VSTSBUG: 4775394 | 3067113
FIX: Access violation and unexpected SQL Server shutdown occur when common criteria compliance is enabled
SQL service

VSTSBUG: 4999045 | 3075939
FIX: An Access Violation occurs when a query uses ISNUMERIC functions in Join conditions in SQL Server 2014 Service Pack 1
SQL performance

VSTSBUG: 5181898 | 3030352
FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 or 2014 database
SQL service

VSTSBUG: 5181900 | 3051243
FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications
SQL service

VSTSBUG: 5181902 | 3069155
FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012
SQL service

VSTSBUG: 5181933 | 3064454
FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012 or SQL Server 2014
SQL performance

VSTSBUG: 4837970 | 3077726
FIX: An online rebuild of indexes is unsuccessful when a table partition is read-only in SQL Server 2014 Service Pack 1
SQL service

VSTSBUG: 4741544 | 3027214
FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012 or SQL Server 2014
Management Tools

VSTSBUG: 5067465 | 3082513
FIX: TDE certificate creation fails in SQL Server 2014 SP1 if the serial number is greater than 16 bytes
SQL security

 

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

  • Microsoft SQL Server 2014 Service Pack 1 ONLY

 

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 2

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:

    SQLServer2014_SP1_CU2_3075950_12_0_4422_x64
    SQLServer2014_SP1_CU2_3075950_12_0_4422_x86

     

Enjoy!