SQL Server 2012 articles, fixes and updates - letter H

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2012 starts with letter H that have been released. The list is daily updated.

• 3188673 High CMEMTHREAD waits on memory object MEMOBJ_SESCHEMAMGR in SQL Server 2012 Q3188673 KB3188673 January 26, 2021
• 3177838 How to use DBCC CLONEDATABASE to generate a schema and statistics only copy of a user database in SQL Server Q3177838 KB3177838 January 26, 2021
• 3171122 How to get prior releases of SQL Server Cumulative Updates Q3171122 KB3171122 January 26, 2021
• 2755533 How to obtain the latest service pack for SQL Server 2012 Q2755533 KB2755533 January 26, 2021
• 2659143 How to enable the "locked pages" feature in SQL Server 2012 Q2659143 KB2659143 January 25, 2021
• 2656988 How to enable the CHECKSUM option if backup utilities do not expose the option Q2656988 KB2656988 January 25, 2021
• 2423478 How to enable Trace Logging in SQL Server 2008 R2 and 2012 Master Data Services Q2423478 KB2423478 January 25, 2021
• 926930 Hard disk drive sector-size support boundaries in SQL Server Q926930 KB926930 January 25, 2021
• 811889 How to troubleshoot the "Cannot generate SSPI context" error message Q811889 KB811889 January 25, 2021
• 316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console Q316898 KB316898 January 25, 2021
• 309422 How to choose antivirus software to run on computers that are running SQL Server Q309422 KB309422 January 25, 2021
• 307487 How to shrink the tempdb database in SQL Server Q307487 KB307487 January 25, 2021
• 2009160 High CPU use occurs when you run queries in SQL Server Q2009160 KB2009160 December 17, 2020
• 969052 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update Q969052 KB969052 December 1, 2020
• 914288 How to generate a script of the necessary database metadata to create a statistics-only database in SQL Server Q914288 KB914288 November 8, 2020
• 917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server Q917825 KB917825 October 20, 2020
• 321185 How to determine the version, edition, and update level of SQL Server and its components Q321185 KB321185 October 1, 2020
• 294209 How to rebuild or move a MSDTC installation to be used with a SQL failover cluster Q294209 KB294209 September 29, 2020
• 945934 How to register Microsoft Filter Pack IFilters with SQL Server Q945934 KB945934 April 30, 2020
• 263889 How to troubleshoot blocking caused by compile locks Q263889 KB263889 December 12, 2019
• 918483 How to reduce paging of buffer pool memory in SQL Server Q918483 KB918483 November 15, 2019
• 312292 How to enable replication agents for logging to output files in SQL Server Q312292 KB312292 April 4, 2019
• 2019698 How to schedule and automate backups of SQL Server databases in SQL Server Express Q2019698 KB2019698 February 18, 2019
• 2015748 How to troubleshoot database consistency errors reported by DBCC CHECKB Q2015748 KB2015748 July 2, 2018
• 926824 How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring Q926824 KB926824 April 18, 2018
• 2015100 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update Q2015100 KB2015100 February 14, 2018
• 2015756 How to troubleshoot Msg 824 in SQL Server Q2015756 KB2015756 November 28, 2017
• 2015755 How to troubleshoot a Msg 823 error in SQL Server Q2015755 KB2015755 November 28, 2017
• 918992 How to transfer logins and passwords between instances of SQL Server Q918992 KB918992 October 9, 2017
• 231619 How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem Q231619 KB231619 October 9, 2017
• 3046875 How to evaluate PDW statistics accuracy Q3046875 KB3046875 November 30, 2016
• 2914662 How to use PFX-formatted certificates in SQL Server Q2914662 KB2914662 August 31, 2015
• 3066750 How to troubleshoot error 20598 "The row was not found at the Subscriber when applying the replicated command" Q3066750 KB3066750 May 29, 2015
• 3046880 How to determine whether cardinality estimation issues are affecting Parallel Data Warehouse (APS) performance Q3046880 KB3046880 May 28, 2015
• 327489 How to use the DisallowAdHocAccess setting to control access to linked servers Q327489 KB327489 May 18, 2015
• 2667175 How to configure SQL Server 2012 to allow for System Center Advisor monitoring Q2667175 KB2667175 July 17, 2014
• 2723587 How to configure SQL Reporting Services in SharePoint Server for Kerberos authentication Q2723587 KB2723587 May 9, 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
• 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
• 2027631 How to troubleshoot SQL Server assertion 'result == LCK_OK' Q2027631 KB2027631 April 23, 2014
• 941232 How to apply a hotfix for SQL Server in a replication topology Q941232 KB941232 February 28, 2014
• 2892633 How to troubleshoot merge replication performance issues by using trace flag 101 Q2892633 KB2892633 October 14, 2013
• 977051 How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology Q977051 KB977051 January 18, 2013
• 2023538 How to setup the custom log shipping which has a RESTORE VERIFY ONLY step Q2023538 KB2023538 January 15, 2013
• 2792138 How to restore a replica to the primary role after the quorum is lost in SQL Server 2012 Q2792138 KB2792138 January 14, 2013
• 2015757 How to troubleshoot Msg 825 (read retry) in SQL Server Q2015757 KB2015757 July 9, 2012