Overview of SQL Server in a SharePoint Server 2013 environment Storage and SQL Server capacity planning and configuration Database management Configure log shipping Backup and recovery overview High availability and disaster recovery concepts Configure an Always On Availability Group ...
This article describes how to plan for and configure the storage and Microsoft SQL Server database tier in a Microsoft SharePoint Server 2010 environment. The capacity planning information in this document provides guidelines for you to use in your planning. It is based on testing performed at Mi...
Capacity planning for tempdb in SQL ServerDetermining the appropriate size for tempdb depends on many factors. These factors include the workload and the Database Engine features that are used.We recommend that you analyze tempdb space consumption by performing the following tasks in a test ...
Install SQL Server Upgrade SQL Server End of support Configuration Uninstall SQL Server Reference Migrate & load data Manage, monitor, & tune Query data Reporting & Analytics Security Tools Tutorials SQL Server on Linux SQL on Azure Azure Arc ...
Therefore, it's important to check the state of SQL Server Service Broker whenever unexpected behavior is observed around a task in System Center Operations Manager.To enable SQL Server Service Broker, follow these steps:Run the following SQL query to check if the broker is already enabled, ...
Using SQL Server PowerShell Extensions 165 Summary 169 Chapter Essentials 169 Chapter 5 Querying SQL Server 171 Understanding the SQL Language 172 Queries 172 Short Learning Curve 173 Varied Query Modes 173 Standardization 175 Added Logical Capabilities of T-SQL 176 ...
Microsoft SQL Server 7.0 Replication Made Easy Microsoft SQL Server 7.0 Security Microsoft SQL Server 7.0 Storage Engine Capacity Planning Tips Microsoft SQL Server Query Processor Internals and Architecture Microsoft SQL Server 7.0 Query Processor Replication for Microsoft SQL Server Version 7.0 SAP R/3...
If you have large reports or large number of users, be sure to do some kind of capacity planning to make sure your report server deployment performs at a level that is satisfactory for your users. For more information about tools and guidelines, see the following publications on MSDN: Plan ...
SQL Server 2008 Full-Text Search: Internals and Enhancements Statistics Used by the Query Optimizer in Microsoft SQL Server 2008 Support for 15,000 Partitions in SQL Server 2008 SP2 and SQL Server 2008 R2 SP1 Troubleshooting Performance Problems in SQL Server 2008 ...
SQL performance Query Optimizer All 2069101 Fixes an issue where Database Mail fails to send email messages and logs the following error message in the SQL Server error log, when used in a contained availability group (AG): The activated proc '[dbo].[sp_sysmail_activate]' running...