SQL Server 2008 R2 articles, fixes and updates - Year 2014

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2008 R2 that have been released in Year 2014. The list is daily updated.

• 2967090 Rendering issues with SQL Server Reporting Services reports in Internet Explorer Q2967090 KB2967090 December 19, 2014
• 2973961 FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server Q2973961 KB2973961 November 17, 2014
• 2134561 The License Agreement link on the Resources page of SQL Server Installation Center is grayed out in SQL Server 20008 and in SQL Server 2008 R2 Q2134561 KB2134561 November 14, 2014
• 2967103 FIX: Service broker stops working when you unregister and remove a session in SQL Server Q2967103 KB2967103 October 21, 2014
• 3010272 Report Builder does not start after Service Pack 3 for SQL Server 2008 R2 is installed Q3010272 KB3010272 October 17, 2014
• 2799534 Various problems may occur when running SQL Server 2012 in Hyper-V or VMWare environment Q2799534 KB2799534 October 17, 2014
• 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 Q2723979 KB2723979 October 9, 2014
• 2963668 FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitions Q2963668 KB2963668 September 30, 2014
• 2920987 FIX: Poor performance when many table-valued parameters are used in SQL Server Q2920987 KB2920987 September 30, 2014
• 2888996 FIX: Data purity corruption in sys.sysbinobjs table in master database when you log on to SQL Server by using the SA account and then run DBCC CHECKDB Q2888996 KB2888996 September 30, 2014
• 3001293 Error 0xC0202009 occurs when SSIS does a parameter cast in SQL Server Q3001293 KB3001293 September 25, 2014
• 2952260 FIX: New FILESTREAM Filegroup can’t be recognized when you alter a partition function with SPLIT RANGE in SQL Server Q2952260 KB2952260 September 15, 2014
• 2862883 FIX: SQL Server performance issues in NUMA environments Q2862883 KB2862883 September 11, 2014
• 2979636 SQL Server generates a 3023 message when backup and file operations are tried at the same time Q2979636 KB2979636 July 3, 2014
• 2922526 FIX: Missing rows on subscriber when you drop and re-add article from another publication or add subscription Q2922526 KB2922526 June 30, 2014
• 2936154 FIX: DTA utility crashes with an access violation when you use user-defined function in SQL Server Q2936154 KB2936154 June 27, 2014
• 2559662 FIX: Slow performance when you render a report that returns a long string of text in SSRS 2008 R2 if the text contains no carriage return characters Q2559662 KB2559662 June 21, 2014
• 2023492 Error: “Unable to load the tables in the PowerPivot window” when you create linked tables in SQL Server 2008 PowerPivot Q2023492 KB2023492 June 21, 2014
• 981973 FIX: The data in a custom report item is displayed incorrectly after you export the report to a PDF format file by using the ReportExecutionService.Render method in SQL Server 2008 Reporting Services or SQL Server 2008 R2 Reporting Services Q981973 KB981973 June 21, 2014
• 956175 You cannot select the first certificate that you create in the Manage Database Encryption window in SQL Server Q956175 KB956175 June 21, 2014
• 2458438 FIX: SQL Server 2008 R2 Analysis Services introduces new trace events to track resource usage and locks by using SQL Server Profiler Q2458438 KB2458438 June 5, 2014
• 2967651 INF: SQL Server may display memory corruption and recovery errors Q2967651 KB2967651 May 20, 2014
• 2567304 FIX: Text is truncated from the DTExec.exe output log file when WshShell.Exec is called if the StdOut stream is redirected Q2567304 KB2567304 May 19, 2014
• 2965553 Decreased performance for SQL Server when you run a TOP, MAX or MIN aggregating clause on columns other than the partitioning column Q2965553 KB2965553 May 15, 2014
• 2605597 FIX: Time-out error when a mirrored database connection is created by the .NET Framework data provider for SQLClient Q2605597 KB2605597 May 15, 2014
• 2555235 FIX: Time-out error when a mirrored database connection is created by the .NET Framework data provider for SQLClient Q2555235 KB2555235 May 15, 2014
• 2696886 [SDP 3][ 788cfaf5-0665-4a69-8ecc-3931f459ecdb] SQL Base Diagnostics Collector Q2696886 KB2696886 May 13, 2014
• 196909 How to increase the number of SQL Server error logs Q196909 KB196909 May 9, 2014
• 2152734 How to troubleshoot SQL Server database consistency errors Q2152734 KB2152734 May 7, 2014
• 2028589 SQL Server reports errors for exceptions, assertions, and hang conditions Q2028589 KB2028589 May 7, 2014
• 2027537 Best Practice recommendations for SQL Server Database Backups Q2027537 KB2027537 May 7, 2014
• 2015747 How to troubleshoot Msg 5180 in SQL Server Q2015747 KB2015747 May 7, 2014
• 2015739 How to troubleshoot Msg 605 with SQL Server Q2015739 KB2015739 May 7, 2014
• 2199578 How to manage the SQL Server error log Q2199578 KB2199578 May 1, 2014
• 2911385 FIX: Replication Queue Reader Agent crashes when you run transactional replication in SQL Server Q2911385 KB2911385 April 25, 2014
• 2913206 FIX: Cannot pass report parameters to reports in a SharePoint Document Library in SSRS by using HTML forms Q2913206 KB2913206 April 21, 2014
• 2904010 FIX: A small number of rows are sampled in SQL Server when table statistics are updated automatically or together with specified sampling rate Q2904010 KB2904010 April 21, 2014
• 2891489 FIX: Replication Log Reader Agent fails when you enable CDC and transactional replication for some columns in SQL Server Q2891489 KB2891489 April 21, 2014
• 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 Q2891230 KB2891230 April 21, 2014
• 2890095 FIX: Interrupted distributed query may return partial result set without any error in SQL Server Q2890095 KB2890095 April 21, 2014
• 2885565 FIX: Report Builder 3.0 may close unexpectedly when you search an attribute in Query Designer in SQL Server Q2885565 KB2885565 April 21, 2014
• 2878377 FIX: DecryptByKeyAutoAsymKey() function returns "NULL" value when you decrypt data that is encrypted by an asymmetric key in SQL Server Q2878377 KB2878377 April 21, 2014
• 2868348 FIX: Chart data cannot be updated when you use the Report Viewer Web Part to view the report in SSRS Q2868348 KB2868348 April 21, 2014
• 2864930 FIX: You cannot write text that has more than 32,767 characters in Report Query Designer in SQL Server Q2864930 KB2864930 April 21, 2014
• 2938136 "Could not find stored procedure sp_server_diagnostics" error and the instances of SQL Server 2008 R2 or SQL Server 2008 cannot fail over in a SQL Server 2012 cluster environment Q2938136 KB2938136 March 12, 2014
• 2903465 Parameter pane is not visible in drillThrough report in SharePoint integrated mode in SSRS Q2903465 KB2903465 March 12, 2014
• 941232 How to apply a hotfix for SQL Server in a replication topology Q941232 KB941232 February 28, 2014
• 2537631 Dimension processing may take longer to complete after you apply SQL Server 2008 R2 Cumulative Update 4 for Analysis Services Q2537631 KB2537631 February 20, 2014
• 2022518 Error message: "Class not registered" when you update PowerPivot data Q2022518 KB2022518 February 18, 2014
• 2923956 "34052" error message and PBM generates alerts on policies that have an evaluation mode in SQL Server Q2923956 KB2923956 February 4, 2014