Microsoft® SQL Server® 2012: Pocket Consultant

Chapter 5. Tuning and Linking Your SQL Servers

• SQL Server Management Studio Essentials

• Working with Linked Servers and Distributed Data

• Configuring Authentication and Auditing

• Tuning Memory Usage

• Configuring Processors and Parallel Processing

• Configuring Threading, Priority, and Fibers

• Configuring User and Remote Connections

• Managing Server Settings

• Managing Database Settings

• Managing Linked Servers

• Troubleshooting Configuration Problems

SQL Server Management Studio is the tool of choice for most server and database management tasks. Using SQL Server Management Studio, you can easily access the properties of a registered server and then use the pages and options provided to tune settings. You also can tune your SQL Servers with Transact-SQL (T-SQL) and Windows ...