Brad’s Sure Guide to SQL Server Maintenance Plans- P2: SQL Server has a reputation as being a simple database application to install, configure, and maintain. This is a little misleading. SQL Server is a powerful relational database that can handle the needs of the largest organizations and, as such, its proper maintenance almost certainly requires the attention of an experienced DBA. | Avoid Overlapping Task Task Scheduling in the Job Schedule Scheduling Individual Maintenance Chapter 5 Check Database Integrity An Overview of the Check Database Integrity When and How Often to Run Integrity Configuring the The Include indexes Creating the Job Chapter 6 Shrink Database Sizing Your Database Problems with the Shrink Database The Right Way to Shrink a Chapter 7 Rebuild Index An Overview of the Rebuild Index When and How Often to Rebuild Tracking Index Offline Index Online Index Scripting Index Configuring the Rebuild Index Database Free space Advanced Creating the Job Chapter 8 Reorganize Index An Overview of the Reorganize Index Reorganize Versus When and How Often to Reorganize Configuring the Reorganize Index Database Compact large Creating the Job Chapter 9 Update Statistics Overview of the Update Statistics When and How Often to Update Configuring the Update Statistics Database The Update The Scan type Option 133 Creating the Job Chapter 10 Execute SQL Server Agent Job An Overview of the Execute SQL Server Agent Job When and How Often to Run the Custom Creating SQL Server Agent Configuring the Execute SQL Server Agent Job Selecting the Creating the Job Chapter 11 History Cleanup An Overview of the History Cleanup When and How Often to Clean Up Configuring the History Cleanup Selecting the Historical
