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 2014 Enterprise

Article ID Article Title Hidden
10179 Troubleshooting SQL Server AlwaysOn Issues
86903 Description of caching disk controllers in SQL Server
195565 Statistical maintenance functionality (AutoStats) in SQL Server
196909 How to increase the number of SQL Server error logs
224071 Troubleshooting SQL Server backup and restore operations
230785 Description of logging and data storage algorithms that extend data reliability in SQL Server
231347 Description of support for SQL Server databases on compressed volumes
231619 How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem
234656 Information about using disk drive caches with SQL Server that every database administrator should know
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
304261 Description of support for network database files in SQL Server
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"
310834 Description of common causes of SQL Server error message 844 or error message 845
312292 How to enable replication agents for logging to output files in SQL Server
315512 Considerations for the "autogrow" and "autoshrink" settings 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
327489 How to use the DisallowAdHocAccess setting to control access to linked servers
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
833770 Support for SQL Server on iSCSI technology components
835185 Microsoft Windows Failover cluster resource dependencies in SQL Server
897284 Diagnostics in SQL Server help detect stalled and stuck I/O operations
914288 How to generate a script of the necessary database metadata to create a statistics-only database in SQL Server
917047 Microsoft SQL Server I/O subsystem requirements for the tempdb database
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
920925 Detours or similar techniques may cause unexpected behaviors with SQL Server
935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
944837 Description of the Replay Markup Language (RML) Utilities for SQL Server
945934 How to register Microsoft Filter Pack IFilters with SQL Server
955644 Description of the "access check cache bucket count" and "access check cache quota" options that are available in the sp_configure stored procedure
956032 Error message when you run the Distribution Agent in SQL Server 2008 or in SQL Server 2008 R2: "The distribution agent failed to create temporary files"
956893 Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment
967576 Microsoft SQL Server Database Engine Input/Output requirements
969052 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update
971268 "Evaluation period has expired" error message when working with SQL server
2002606 OS errors 1450 and 665 are reported for database data files
2027537 Best Practice recommendations for SQL Server Database Backups
2028436 Database operations take a long time to complete, or they trigger errors when the transaction log has numerous virtual log files
2028589 SQL Server reports errors for exceptions, assertions, and hang conditions
2033238 Performance and consistency issues when certain modules are loaded into SQL Server address space
2152734 How to troubleshoot SQL Server database consistency errors
2154845 Recommendations to reduce allocation contention in SQL Server tempdb database
2199578 How to manage the SQL Server error log
2295405 SQL Server service crashes when you run an Oracle linked server query
2407439 You may notice an increased transaction log sizes in SQL Server 2008 and later versions when you perform Index Maintenance