Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Articles for product: SQL Server 2016 Enterprise

Article ID Article Title Hidden
10179 Troubleshooting SQL Server AlwaysOn Issues
224071 Troubleshooting SQL Server backup and restore operations
231619 How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem
263889 How to troubleshoot blocking caused by compile locks
294209 How to rebuild or move a MSDTC installation to be used with a SQL failover cluster
307487 How to shrink the tempdb database in SQL Server
307864 Error message when you connect to an instance of SQL Server: "Cannot open user default database"
312292 How to enable replication agents for logging to output files in SQL Server
316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console
321185 How to determine the version, edition, and update level of SQL Server and its components
327518 The Microsoft Support Policy for Clustered Configurations of SQL Server with Windows Server
811889 How to troubleshoot the "Cannot generate SSPI context" error message
835185 Microsoft Windows Failover cluster resource dependencies in SQL Server
870668 Reporting Services cannot run reports against Oracle databases
917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server
918483 How to reduce paging of buffer pool memory in SQL Server
918992 How to transfer logins and passwords between instances of SQL Server
935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
945934 How to register Microsoft Filter Pack IFilters with SQL Server
956893 Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment
969052 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update
2002606 OS errors 1450 and 665 are reported for database data files
2033238 Performance and consistency issues when certain modules are loaded into SQL Server address space
2295405 SQL Server service crashes when you run an Oracle linked server query
2618570 "0x80770006" and "3201" errors after you install an instance of SQL Server 2008 R2 and later versions
2681562 Using SQL Server in Windows 8 and later versions of Windows operating system
2754171 Controlling Autostat (AUTO_UPDATE_STATISTICS) behavior in SQL Server
2871474 SQL Transaction log grows when you use Change Data Capture for Oracle by Attunity
2922898 "Error 9002. The transaction log for database is full due to 'AVAILABILITY_REPLICA'" error message in SQL Server
3092936 Increased CPU usage when you access a SQL Server FileTable share from Windows Explorer
3108695 Client connectivity issues because of changes in name resolution in SQL Server 2014 or later
3159748 FIX: Cannot connect to a named instance after failover on a mirror server in SQL Server 2014 or 2016
3163368 Max_Queue_Readers property is ignored when you try to limit activation tasks in Service Broker
3189675 Join containment assumption in the New Cardinality Estimator degrades query performance in SQL Server 2014 and later
3191316 Words that have leading decimal points are not returned by an English word breaker in SQL Server
3195161 Defragmenting SQL Server database disk drives
3196320 SQL query times out or console slow on certain Configuration Manager database queries
3196535 Description of the Update Cache folder in SQL Server
3199641 MS16-136: Security update for SQL Server: November 8, 2016
3200464 Error when you attach a CDC-enabled database to an instance of SQL Server 2016 or SQL Server 2017 on Windows
3201336 Low transaction throughput on Always On Availability Group primary replica
3204545 The .NET Framework 4.6.2 client driver for "Always Encrypted" intermittently fails during row decryption
3210239 Interoperability of Columnstore indexes with large page memory model in SQL Server
3212023 Performance degradation when you upgrade from database compatibility level 120 to 130 in SQL Server 2016 or in SQL Server 2017 on Windows
4010261 SQL Server and Azure SQL Database improvements in handling some data types and uncommon operations
4013883 FIX: Data type conversion error due to late evaluation of a filter predicate in a query involving a column store index in SQL Server 2016
4014354 How to use SQL Server 2016 in FIPS 140-2-compliant mode
4014732 FIX: A memory leak in SQLWEP causes the host process Wmiprvse.exe to crash in SQL Server
4015034 FIX: An assertion occurs when you run an UPDATE statement on a clustered columnstore index in SQL Server 2016
4015561 FIX: Access violation when a stored procedure is dropped before you execute END TRY section in SQL Server