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

Just one update package in July. In this Cumulative Update No 7 {build 11.0.5623.0} for Microsoft SQL Server 2012 Service Pack 2 (SP2) released two weeks ago Microsoft fixed thirty four bugs. Important information for all DBA (and their SEC friends) is that SQL Server 2012 SP2 Cumulative Update 7 contains the recently released Security Bulletin MS15-058 (KB3065718).

VSTSBUG: 3983191 | 3029096
FIX: The changes in Oracle databases are not replicated to SQL Server 2012 or SQL Server 2014 databases correctly
Integration Services

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

VSTSBUG: 4178633 | 3052461
FIX: Some attributes in element are ignored when you transform XML file in SSIS 2012
Integration Services

VSTSBUG: 4639762 | 3062001
FIX: “Failed to create kernel event for collection set” error occurs when you use Data Collection in SQL Server 2012
Management Tools

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

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

VSTSBUG: 4715206 | 3065060
FIX: “Unable to create restore plan due to break in the LSN chain” error when you restore differential backup in SSMS
Management Tools

VSTSBUG: 4743330 | 3068351
FIX: ROLAP Distinct Count on data source is not started when it is running from SSAS 2012 to back-end SQL Server 2014
Analysis Services

VSTSBUG: 4662556 | 3068359
FIX: “Cannot find the OLAP cube Model” error when you update the pivot table in a SharePoint document in SQL Server 2012
Analysis Services

VSTSBUG: 4520905 | 3068439
FIX: Indexed view returns incorrect result after insert or delete operation on the base table in SQL Server 2012
SQL performance

VSTSBUG: 4694348 | 3068468
FIX: Schema lock occurs on a table with large data when you delete lots of rows from it in SQL Server 2012
SQL service

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

VSTSBUG: 4805976 | 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
SQL performance

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

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

VSTSBUG: 4925413 | 3073530
FIX: Access Violation error occurs when you run DDL SQL statements on a database in an instance of SQL Server 2012
Analysis Services

VSTSBUG: 4500307 | 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: 4928677 | 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: 4683321 | 3074922
FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012
SQL performance

VSTSBUG: 4547054 | 3074425
FIX: Contention occurs when you execute many ad-hoc queries in SQL Server 2012
SQL service

VSTSBUG: 5013383 | 3075176
FIX: You receive incorrect results from the CHANGETABLE() function when snapshot isolation for a SQL Server 2012 database
SQL service

VSTSBUG: 4495133 | 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 SP2
SQL service

VSTSBUG: 4781857 | 3075669
FIX: SSAS 2012 crashes when you execute an MDX query that contains a large number of Union expressions
Analysis Services

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

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

VSTSBUG: 4933896 | 3073907
FIX: A SQL Server 2012 SSIS package with an Execute SQL Task may stop responding
Analysis Services

VSTSBUG: 4691746 | 3063438
FIX: XSLT transformation fails when you run an SSIS 2014 package that contains multiple concurrent XML tasks
Integration Services

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

VSTSBUG: 4939175 | 3070147
FIX: Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server
SQL service

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

VSTSBUG: 4817323 | 3069320
FIX: A workflow never starts in a SharePoint 2013 environment when you use SQL Server 2012 Master Data Services to start the workflow
MDS

VSTSBUG: 4465179 | 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: 4834221 | 2820068
FIX: Can’t install SQL Server by using InstallShield or bootstrapping application
Setup & Install

 

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

  • Microsoft SQL Server 2012 Service Pack 2 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 7

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:

    SQLServer2012_SP2_CU7_3072100_11_0_5623_x64
    2012_SP2_AOrcleDes_CU7_3072100_11_0_5623_x64
    2012_SP2_AOrcleSer_CU7_3072100_11_0_5623_x64
    2012_SP2_AOrcleDes_CU7_3072100_11_0_5623_x86
    SQLServer2012_SP2_CU7_3072100_11_0_5623_x86
    2012_SP2_AOrcleSer_CU7_3072100_11_0_5623_x86

     

Enjoy!

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

LOGO__SQLServer2012Two updates pack has been published one day ago. Second pack is for SQL Server 2012 SP1. In this Cumulative Update No 7 (build number: 11.0.3393.0 / 778 MB in zipped file for x64 env.) Microsoft fixed many (about fifty) submitted bugs. Here is the list, but it’s strongly recommended to read details about those bugs, before installing this update in Your environment:

VSTS BUG: 1282810 | 2792921
FIX: Description of new features in SQL Server 2012 and SQL Server 2008 R2 SP2

VSTS BUG: 1615704 | 2833989
FIX: Object ID that is used in memory differs from the object ID on the disk in SQL Server 2012

VSTS BUG: 1268467 | 2843619
FIX: Tablix column header sorting buttons are Section 508 noncompliant in a Reporting Services report in SQL Server 2012

VSTS BUG: 1497516 | 2844210
FIX: The Remote Registry service crashes when an application tries to retrieve Performance Counter data from another computer

VSTS BUG: 1357295 | 2862241
FIX: Access violation when you trace an RPC event class by using SQL profiler or XEvents in SQL Server 2012

VSTS BUG: 1497535 | 2866062
FIX: Access violation when you use DTA to analyze a database that contains a partition table in SQL Server 2008 R2 or in SQL Server 2012

VSTS BUG: 1497537 | 2868348
FIX: Chart data cannot be updated when you use the Report Viewer Web Part to view the report in SSRS 2008 R2 or in SSRS 2012

VSTS BUG: 1525444 | 2878968
FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012

VSTS BUG: 1447550 | 2879373 
FIX: The threads are not scheduled evenly in SQL Server 2012 Standard Edition

VSTS BUG: 1455690 | 2881285
FIX:  You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012

VSTS BUG: 1434542 | 2881661
FIX: A memory leak occurs when a SQL Server Native Client OLE DB provider application calls the Prepare method in SQL Server 2012

VSTS BUG: 1465290 | 2883424
FIX: Dragged objects shake in an SSIS 2012 project after you apply Cumulative Update 6 for SQL Server 2012

VSTS BUG: 1465483 | 2883524
FIX: "SCN not found" error when you use Connector for Oracle by Attunity and CDC for Oracle by Attunity in SQL Server 2012

VSTS BUG: 1480767 | 2884953 
FIX: "Non-yielding Resource Monitor" when you run a workload that executes concurrent queries in SQL Server 2012

VSTS BUG: 1482635 | 2885671
FIX: Duplicated worksheets are opened when you use the SQL Server Master Data Services Add-in for Microsoft Excel in SQL Server 2012

VSTS BUG: 1492999 | 2887115
FIX: Function sys.fn_hadr_backup_is_preferred_replica costs almost all the CPU usage in Log Shipping in SQL Server 2012

VSTS BUG: 1581425 | 2887888
FIX: Slow performance in SQL Server when you build an index on a spatial data type of a large table in a SQL Server 2012 instance

VSTS BUG: 1581526 | 2887899 
FIX: Slow performance in SQL Server 2012 when you build an index on a spatial data type of a large table

VSTS BUG: 1502271 | 2888658
FIX: An access violation occurs when "sys.dm_db_index_physical_stats" is used in an IF EXISTS statement in an SQL query in SQL Server 2012

VSTS BUG: 1499492 | 2889492
FIX: You can’t open the SQL Server Analysis Services properties dialog box in Windows 8.1

VSTS BUG: 1519097 | 2889723
FIX: A series of errors occurs when you export a Reporting Services report as a PDF in SQL Server 2012

VSTS BUG: 1519527 | 2890052
FIX: Integration Services catalog permissions don’t work for Windows groups in SQL Server 2012

VSTS BUG: 1530003 | 2890415
FIX: Notification messages are not received when data updates fail in a PowerPivot sheet in an instance of SQL Server 2012 Service Pack 1 Analysis Services

VSTS BUG: 1482450 | 2891083
FIX: Subscriptions does not have an option to use default parameter values that are based on expressions in SSRS 2012 in SharePoint Integrated mode

VSTS BUG: 1531889 | 2891088
FIX: Find option in Report Manager always takes you to the bottom of the page in SSRS 2012

VSTS BUG: 1607598 | 2891230
FIX: Error message when you select a report on the RSItemPicker.aspx page after you apply update 2791086 on a computer that is running SSRS 2008 R2 or SSRS 2012

VSTS BUG: 1465349 | 2893842
FIX: Fewer results in the MDS subscription view after you apply SQL Server 2012 SP1 or SQL Server 2012 CU2

VSTS BUG: 1499658 | 2894025
FIX: Mirror tables are dropped when you use "Change Data Capture for Oracle by Attunity" on a server that is running SQL Server 2012

VSTS BUG: 1577746 | 2894305
FIX: Suboptimal execution plan is generated when you run a query in SQL Server 2012

VSTS BUG: 1577767 |2894326
FIX: An application cannot connect to a contained database when connection pooling is enabled in SQL Server 2012

VSTS BUG: 1590906 | 2895494
FIX: Slow SQL Server performance and a memory leak occurs after you apply Cumulative Update 3 for SQL Server 2012 Service Pack 1

VSTS BUG: 1560706 | 2895694
FIX: Query scope assignment works incorrectly after you run a ClearCache command in SSAS 2012

VSTS BUG: 1599658 | 2896505
FIX: Blank values for a DAX formula are seen in PowerPivot for Excel in SQL Server 2012 Analysis Services

VSTS BUG: 1494708 | 2896720
FIX: Slow performance in SQL Server 2012 when you build an index on a spatial data type of a large table

VSTS BUG: 1578576 | 2897221
FIX: Slow performance or error messages are logged when you have a transactional replication publisher server in SQL Server 2012

VSTS BUG: 1607184 | 2897237
FIX: Transaction date format on an MDS website in SQL Server 2012 differs from the format that is defined on the computer

VSTS BUG: 1460938 | 2897263
FIX: "An error occurred when loading VertiPaq data" error occurs after you run DISCOVER_XML_METADATA Rowset or load a database and then start a trace in SQL Server 2012 Analysis Services

VSTS BUG: 1584328 | 2897265
FIX: "Invalid column name" error when you run some MDX queries against ROLAP partitions in SSAS 2012

VSTS BUG: 1607493 | 2897282
FIX: Wrong date format will be returned when you run DateAdd or Day function in SSAS 2012 on a non-US locale computer

VSTS BUG: 1596224 | 2897454
FIX: Insufficient system memory error occurs when you try to create an index in a char, varchar, or nvarchar type column in SQL Server 2012

VSTS BUG: 1602357 | 2897512
FIX: Newly added member disappears from the Master Data Explorer in SQL Server 2012 MDS

VSTS BUG: 1610265 | 2897539
FIX: IntelliSense feature does not work correctly after you type Transact-SQL statements in SSMS in SQL Server 2012

VSTS BUG: 1615705 | 2897554
FIX: Synchronization state of an AlwaysOn Availability Group replica may not be updated if primary is unhealthy

VSTS BUG: 1610741 | 2897633
FIX: You cannot start an audit by using an "ALTER" statement in SQL Server 2012

VSTS BUG: 1530104 | 2899945
FIX: "The report server cannot process the report" error when you view an SSRS 2012 report on a SharePoint website

VSTS BUG: 1631258 | 2900127
FIX: "PowerPoint was unable to open or save this document." error message after you modify an embedded PowerPivot table

VSTS BUG: 1559163 | 2905275
FIX: "The operation was cancelled by the user" error message when you run some MDX or DAX queries in SSAS 2012

VSTS BUG: 1460958 | 2905298
FIX: It takes much longer for a user without administrator permissions to run an MDX query than an administrator user in SSAS 2012

 

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 Standard
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 SP1 PowerPivot for Microsoft Excel 2010

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 7

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

  • SQL Server 2012 | x86 | 2012_SP1_DAC_CU7_2894115_11_0_3393_x86
  • SQL Server 2012 | x86 | 2012_SP1_AOrcleDes_CU7_2894115_11_0_3393_x86
  • SQL Server 2012 | x86 | 2012_SP1_AOrcleSer_CU7_2894115_11_0_3393_x86
  • SQL Server 2012 | x86 | SQLServer2012_SP1_CU7_2894115_11_0_3393_x86
  • SQL Server 2012 | x64 | SQLServer2012_SP1_CU7_2894115_11_0_3393_x64
  • SQL Server 2012 | x64 | 2012_SP1_RSShrPnt_CU7_2894115_11_0_3393_x64
  • SQL Server 2012 | x64 | 2012_SP1_AOrcleSer_CU7_2894115_11_0_3393_x64
  • SQL Server 2012 | x64 | 2012_SP1_PPExcel_CU7_2894115_11_0_3393_x64
  • SQL Server 2012 | x64 | 2012_SP1_AOrcleDes_CU7_2894115_11_0_3393_x64

Enjoy!

[EN] SQL Server 2008 R2 Service Pack 1 Cumulative Update 7 is available

LOGO__SQLServer2008R2Sp1The second one for today’s update packages are for SQL Server 2008 R2 with Service Pack 1. In previous post I wrote about SQL Server 2008 R2 and in next I’m going to write about new SQL Server 2012.

In this Cumulative Update 7 [version build: 10.50.2817.0.] Microsoft resolved & fixed a lot of bugs for five components:
* for SQL Server Engine
* for SQL Server Analysis Services
* for SQL Server Reporting Services
* for SQL Server Manageability
* for SQL Server Connectivity

Below You can find short information about fixed bugs:

VSTS BUG: 801801 | 2618676
FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 934419 | 2625768
FIX: A database page is copied into a database snapshot even though the page is not updated when you perform a read operation in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 898890 | 2658474
FIX: Incorrect results when the SqlConnection.GetSchema method retrieves a table’s schema information in SQL Server 2008, in SQL Server 2008 R2, or in SQL Server 2012

VSTS BUG: 860526 | 2661644
FIX: Access violation might occur in the sqlservr!ReplicaToPrimaryPageCopier::ReadIoCompletionRoutine function in SQL Server 2008 R2

VSTS BUG: 867697 | 2667037
FIX: “The connection string format is not valid” error when you try to create a maintenance plan for a SQL Server 2008 R2 server

VSTS BUG:  934435 | 2673997
FIX: “The index data is damaged” error message when you run an MDX query against a dimension or partition in SSAS 2008, in SSAS 2008 R2, or in SSAS 2012

VSTS BUG: 919031 | 2674636
FIX: The size of a database file is not reduced when you use the DBCC SHRINKFILE command in SQL Server 2008 R2

VSTS BUG: 919029 | 696161
FIX: Error message when you try to view a report in SSRS 2008 R2: “Different query parameters resulted in a same hash”

VSTS BUG: 905366 | 697983
FIX: An incorrect value is stored in the TIME_ZONE column of the BACKUPSET table in SQL Server 2008 R2

VSTS BUG: 905383 | 2699013
FIX: SQL Server 2008 R2 stops responding and a “Non-yielding Scheduler” error is logged

VSTS BUG: 921060 | 2703152
FIX: Access violation when you call a CLR stored procedure that references a user-defined table type parameter in SQL Server 2012 or in SQL Server 2008 R2

VSTS BUG: 924055 | 2703214
FIX: SQL Server 2008 R2 may not accept the client connection request when you perform a bulk insert, and an OS error occurs

VSTS BUG: 952564 | 2706518
FIX: The KeepFilesForDays setting does not work in SQL Server 2008 or in SQL Server 2008 R2 Reporting Services

VSTS BUG: 928501 | 2706519
FIX: An exception occurs when the SqlCommandBuilder.DeriveParameters method is used to retrieve parameter information from a CLR stored procedure in SQL Server 2008 R2

VSTS BUG: 928854| 2706601
FIX: Series groups in a report are missing when you display the report in SQL Server 2008 Reporting Services or in later versions of Reporting Services

VSTS BUG: 929551 | 2707015
FIX: rsInternalError error when you export a report that contains a Tablix control in SSRS 2008 R2

VSTS BUG: 930436 | 2708027
FIX: “An error has occurred during report processing” error message when you try to preview an SSRS 2008 R2 report after you set the dataset collation to Greek or Greek_100

VSTS BUG: 931133 | 2708726
FIX: The Agent perfmon DLL files in the system32 folder are not updated as expected after you apply new updates for SQL Server 2008 R2

VSTS BUG: 934250 | 2711549
FIX: “Non-yielding IOCP Listener” error message when you start SQL Server 2008 R2 or a client sends a request to the SQL Server 2008 R2

VSTS BUG: 948176 | 2713501
FIX: A deadlock occurs when you alter a partition and run a statement against the partition at the same time in SQL Server 2008 R2

VSTS BUG: 950155 | 2714634
FIX: SQL Server 2008 R2 takes a long time to generate scripts for the table that uses data compression

VSTS BUG: 951083 | 2715289
FIX: Incorrect results when you convert a datetimeoffset column to a smalldatetime column in SQL Server 2008 R2 when there is an index on the datetimeoffset column

VSTS BUG: 951029 | 2715312
FIX: Errors when you run a query that uses the FOR XML clause in the PATH mode in SQL Server 2008 R2

VSTS BUG: 868175 |  2722165
FIX: The restore behavior does not stop at the time that you defined in SQL Server 2008 R2

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 7

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, itanium). This release is prepared as multilingual package.