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

LOGO__SQLServer2014Two weeks ago Microsoft released two new packages with cumulative updates. In my first post I writing about Cumulative Update No 9 {build 12.0.2553.0} for SQL Server 2014 RTM release. In this package Microsoft fixed about thirty bugs and here is the list:

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

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

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

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

VSTSBUG: 5181897 | 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: 5181899 | 3051243
FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications
SQL service

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

VSTSBUG: 5181929 | 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: 5181931 | 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: 5181936 | 2965654
FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer
Reporting Services

VSTSBUG: 5181954 | 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: 4157566 | 3038876
FIX: It takes longer time than expected to list the databases in Object Explorer in SSMS 2014
Management Tools

VSTSBUG: 5186732 | 3082005
FIX: Case-sensitive does not work in MDS database in SQL Server 2014
Master Data Services (MDS)

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

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

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

VSTSBUG: 5020180 | 3081020
FIX: A stalled dispatcher system dump occurs resulting in failover and service outage on the availability groups in SQL Server 2014
High Availability

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

VSTSBUG: 5181907 | 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: 5181913 | 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: 5181915 | 3074425
FIX: CMEMTHREAD waits occur when you execute many ad hoc queries in SQL Server 2012 or SQL Server 2014
SQL service

VSTSBUG: 5181923 | 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: 5181956 | 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
MDS

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

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: 4811930 | 3072814
FIX: Access violation occurs when you connect to an instance of SQL Server by using sqlcmd utility in SQL Server 2014
SQL connectivity

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

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

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

VSTSBUG: 5181917 | 3061215
FIX: “Cannot read 8 bytes from file” error occurs when you use SSIS 2012 or 2014
Integration Services

 

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 9

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_RTM_CU9_3075949_12_0_2553_x64
    SQLServer2014_RTM_CU9_3075949_12_0_2553_x86

     

Enjoy!

[EN] SQL Server 2012 SP1 Cumulative Update 9 is available

LOGO__SQLServer2012SP1Two weeks ago, two cumulative packages for two different SQL Server versions. This is the post about second of two. In this Cumulative Update No 9 (build no 11.0.3412.0) Microsoft fixed over thirty bugs for many parts of SQL Server environment. Here is the list of fixed bugs (with new feature – Fix Area):

VSTS BUG: 2027275 | 2723979
FIX: Access violation in SQL Server internal deadlock monitor when you run multiple applications together with Multiple Active Result Sets enabled in SQL Server 2008 R2 or in SQL Server 2012
SQL service

VSTS BUG: 2041570 | 2861456
FIX: Access violation in replication Distribution Agent in SQL Server 2008 R2 or SQL Server 2012 Transactional Replication
SQL service

VSTS BUG: 1852108 | 2913206
FIX: Cannot pass report parameters to reports in a SharePoint Document Library in SSRS 2008 R2 or SSRS 2012 by using HTML forms
Reporting Services

VSTS BUG: 2076868 | 2920987
FIX: Poor performance when many table-valued parameters are used in SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTS BUG: 1993314 | 2921630
FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS 2008 or SSAS 2008 R2 or SSAS 2012
Analysis Services

VSTS BUG: 1920886 | 2922935
FIX: Excel rendering extension produces corrupted files when you use nonprintable codes in SSRS 2012
Reporting Services

VSTS BUG: 1993311 | 2923837
FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTS BUG: 1941216 | 2924827
FIX: dtexec.exe cannot execute a package when one of the configuration files does not exist in SQL Server 2012
Integration Services

VSTS BUG: 1966828 | 2926089
FIX: Error when you create new report subscriptions after you apply CU7 or CU8 for SQL Server 2012 SP1
SQL security

VSTS BUG: 2021036 | 2926217
FIX: Performance problems occur when database lock activity increases in SQL Server 2012
SQL service

VSTS BUG: 2021037 | 2926223
FIX: Performance problems occur in NUMA environments during foreign page processing in SQL Server 2012
SQL service

VSTS BUG: 1972245 | 2926699
FIX: Operating system version information that is returned from SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012 is incorrect in Windows 8.1
SQL service

VSTS BUG: 2021038 | 2926712
FIX: Performance decreases after an ALTER INDEX…ONLINE operation is aborted in SQL Server 2012
SQL service

VSTS BUG: 1994633 | 2927511
FIX: Access violation may occur when trigger query joins large dataset in deleted/inserted table and runs in parallel in SQL server 2012
SQL performance

VSTS BUG: 1994687 | 2927524
FIX: MDX query does not reuse cache after clear cache command on different Measure Group with Non-Admin login in SSAS 2012
Analysis Services

VSTS BUG: 2021039 | 2927748
FIX: PowerPivot workbook cannot do data refresh in SharePoint 2013 after you apply SQL Server 2012 CU7
Analysis Services

VSTS BUG: 1999508 | 2927779
FIX: Database shows "recovery pending" state when you use TDE with EKM provider in SQL Server 2012
SQL security

VSTS BUG: 1999683 | 2927844
FIX: Large DistinctCount become slower in tabular mode in SQL Server 2012
Analysis Services

VSTS BUG: 1968031 | 2929193
FIX: SQL Server 2012 instance shuts down when you join database as secondary replica during AlwaysOn Availability Groups configuration
High Availability

VSTS BUG: 1929567 | 2929832
FIX: Decimal precision is incorrect when you calculate based on size of scale in SQL Server 2012 MDS
Data Quality Services (DQS)

VSTS BUG: 1924585 | 2929903
FIX: Merge agent fails when you apply snapshot in SQL Server 2012 instance if cross database dependencies are present
SQL service

VSTS BUG: 2024625 | 2931001
FIX: Distribution Agent skips applying sp_MSins_, sp_MSupd_, sp_MSdel_ stored procedures on a Subscriber that is initialized with Backup in SQL Server 2012
SQL service

VSTS BUG: 2032571 | 2931241
FIX: Access violation occurs when you update a table that has an XML calculated column in SQL Server 2012
SQL service

VSTS BUG: 2047687 | 2932120
FIX: SQL Server takes long time to open the databases after the recovery phase when the number of databases or database files or both is large in SQL Server 2012
SQL service

VSTS BUG: 2035100 | 2932340
FIX: Errors when you add member in SQL Server 2012 MDS
DQS

VSTS BUG: 2043007 | 2932341
FIX: Content of member details window is locked when you add a new member to MDS Explorer in SQL Server 2012 MDS
DQS

VSTS BUG: 1909862 | 2933780
FIX: Message is not removed from transmission queue even though the ACK is received successfully in an AlwaysOn availability group in SQL Server 2012
SQL service

VSTS BUG: 2022961 | 2934934
FIX: Non-yielding scheduler tries to close the listener for availability group in SQL Server 2012
High Availability

VSTS BUG: 2082516 | 2935681
FIX: Bing Map functionality does not work in Power View or SSRS 2012
Reporting Services

 

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

  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web

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 09

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 platforms: 32-bit and 64-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

>> x86 | 2012_SP1_PPExcel_CU9_2931078_11_0_3412_x86
>> x86 | 2012_SP1_DAC_CU9_2931078_11_0_3412_x86
>> x86 | SQLServer2012_SP1_CU9_2931078_11_0_3412_x86
>> x64 | 2012_SP1_DAC_CU9_2931078_11_0_3412_x64
>> x64 | 2012_SP1_RSShrPnt_CU9_2931078_11_0_3412_x64
>> x64 | SQLServer2012_SP1_CU9_2931078_11_0_3412_x64
>> x64 | 2012_SP1_PPExcel_CU9_2931078_11_0_3412_x64

Enjoy!

[EN] SQL Server 2008 Service Pack 3 Cumulative Update 9 is available

LOGO__SQLServer2008SP3On 21st January Microsoft released Cumulative Update No 9 for SQL Server 2008 with Service Pack 3. In this Cumulative Update 9 [version build 10.00.5829.00] resolved three bugs listed below and wchich could be applied for:

  • Microsoft SQL Server 2008 Service Pack 3
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Workgroup

Here is the list of bugs:

VSTS BUG: 1131071 | 2802244
FIX: Installation or upgrade process fails when you install or upgrade a SQL Server 2008 clustered instance on mount points

VSTS BUG: 1145633 | 2791745
FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008

VSTS BUG: 1113313 | 2780146
FIX: "Incorrect syntax near ‘IDENTITY_VALUE’" error when you try to decrypt data that is migrated from another database in SQL Server 2008 R2 or in SQL Server 2008

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 9

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 32-bit, 64-bit and Itanium). This release is prepared as multilingual package.