Lesson 21. Configuring, Maintaining, and Tuning SQL Server

The most attractive application can be extremely frustrating to use if its performance is less than acceptable. As a developer, you must take precautions to try to assure that the SQL Server is as lean and efficient as possible. This lesson explains:

Image How to select and tune your hardware

Image How to configure and tune SQL Server

Image How to maintain your databases

How to maintain your tables and other ...

Get Sams Teach Yourself T-SQL in One Hour a Day now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.