[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 SP3 Cumulative Update 14 is available

LOGO__SQL_ServerTwo updates pack has been published one day ago. First pack is for SQL Server 2008 SP3. In this Cumulative Update No 14 (build number: 10.00.5848.00 / 210 MB in zipped file for x64 env.) Microsoft fixed six submitted bugs. Here is the list:

VSTS BUG: 1517718 | 2591461
FIX: "Unexpected error from SE OLEDB interface" error when you run a full-text search query in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 1480650 | 2884888
FIX: Unable to click OK or Cancel in the query designer in BIDS 2008 or in SQL Server 2008 Report Builder

VSTS BUG: 1494726 | 2887465
FIX: You receive an incorrect result when you run a query that uses some ranking functions in SQL Server 2008

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

VSTS BUG: 1560626 | 2892741
FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008

VSTS BUG: 1596875 | 2901479
FIX: You experience query failure when you run MDX queries in SSAS 2008

 

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

  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Reporting Services

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 14

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

  • SQL Server 2008 | x86 | SQLServer2008_SP3_CU14_2893410_10_00_5848_x86

  • SQL Server 2008 | x64 | SQLServer2008_SP3_CU14_2893410_10_00_5848_x64

  • SQL Server 2008 | ia64 | SQLServer2008_SP3_CU14_2893410_10_00_5848_IA64

Enjoy!