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 Developer

Article ID Article Title Hidden
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
917825 How to use the Sqldumper.exe utility to generate a dump file 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
2681562 Using SQL Server in Windows 8 and later versions of Windows operating system
2871474 SQL Transaction log grows when you use Change Data Capture for Oracle by Attunity
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
3185365 SQL Server 2016 Agent fails to start or “Failed to retrieve data” error when you try to read error log from SSMS 2016
3189675 Join containment assumption in the New Cardinality Estimator degrades query performance in SQL Server 2014 and later
3195161 Defragmenting SQL Server database disk drives
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
4019701 FIX: Database schema is corrupted when you restore a database from a snapshot in SQL Server
4023373 Event ID 17141 is logged when SQL Server does not come online in Windows Failover Clustering
4033835 Access violations and memory dump files when you use XEvent session with sqlos.wait_info event in SQL Server
4038932 FIX: Change Data Capture functionality does not work in SQL Server
4045273 Full-text indexes stop populating for 30 minutes in SQL Server
4046801 “Cannot apply value 'null' to property ServerInstance" error when looking at subscription properties in SQL Server 2017 or 2016
4047327 Non-applicable SQL Server CUs are listed in WSUS, MU, or ConfMgr
4052134 FIX: Errors 33111 and 3013 when backing up TDE-encrypted database in SQL Server