Maintaining a SQL Server database is critical to ensuring that your database environment performs reliably and efficiently. Although advances in the SQL Server platform have made maintenance activities simpler and more straightforward, it is critical that DBAs understand the following:
Which database maintenance tasks need to be performed and why
When to perform them
How to perform them
In this chapter, we cover a series of important database maintenance tasks, how to determine whether and when they need to be performed, and ways to perform those tasks. Subsequent chapters build upon this one by showing you how to use different tools, such as PowerShell, and by showing you how to define maintenance plans ...