Maintenance

Valuable SQL Server Maintenance tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.

Title Author Date
Update Statistics for All Tables and Databases in SQL Server Eduardo Pivaral2025-06-16
SQL Server Maintenance Tasks You Probably Aren’t Doing MSSQL Tips2024-04-23
Transfer SQL Server Maintenance Plans Between Servers Sergey Gigoyan2020-04-20
SQL Server Maintenance Plans Maintenance Cleanup Task Sergey Gigoyan2020-03-02
SQL Server Maintenance Plans History Cleanup Task Sergey Gigoyan2020-02-18
SQL Server Maintenance Plan Shrink Database Task Sergey Gigoyan2020-01-10
SQL Server Maintenance Plan Execute T-SQL and SQL Server Agent Job Tasks Sergey Gigoyan2019-12-27
Create SQL Server Maintenance Plan with Maintenance Plan Designer Sergey Gigoyan2019-09-30
Getting Started with SQL Server Maintenance Plans – Part 1 Sergey Gigoyan2019-07-24
SQL Server Maintenance Plan Index Rebuild and Reorganize Tasks Dinesh Asanka2019-05-14
Move SQL Server Maintenance Plan from One Server to Another Nisarg Upadhyay2018-03-22
Finding and Cleaning Up Old SQL Server Job Log Files Bernard Black2017-01-10
How to Identify Useful SQL Server Table Statistics Fikrat Azizov2016-05-18
Resolve SQL Server Database Index Reorganization Page Level Locking Problem Ahmad Yaseen2016-04-14
Automate Out of Date SQL Server Statistics with PowerShell Tim Smith2016-03-09
SQL Server Index Reorganization vs Rebuild Performance Impact – Part 2 Ben Snaidero2015-04-23
Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table Daniel Farina2015-03-30
SQL Server Maintenance Plans Reporting and Logging Brady Upton2014-05-01
Reduce Time for SQL Server Index Rebuilds and Update Statistics Norman Chan2014-01-17
Using WITH ROWCOUNT and PAGECOUNT option of SQL Server UPDATE STATISTICS Ben Snaidero2013-01-30
Script to Recompile All SQL Server Database Objects Jeremy Kadlec2012-05-07
Creating SQL Server password protected backups and cleanup tasks Atif Shehzad2010-04-14
Changing passwords for logins used with SQL Server maintenance plans Atif Shehzad2010-03-30
SQL Server 2005 transaction log backup maintenance plan via SSIS Michelle Gutzait2009-05-19
Execute UPDATE STATISTICS for all SQL Server Databases Tim Ford2008-10-17
Maintenance task to delete old SQL Server backup files Greg Robidoux2007-09-06
SQL Server transaction log backups always fail with maintenance plan Greg Robidoux2007-04-10
AUTO_UPDATE_STATISTICS_ASYNC SQL Server Database Configuration Chad Boyd2007-03-06
Performing SQL Server Maintenance with No Maintenance Window Jeremy Kadlec2006-12-28
Supporting tables for SQL Server 2005 style maintenance plans Greg Robidoux2006-12-18
Perform Maintenance with SQL Server Databases in Full Recovery mode Jeremy Kadlec2006-12-12
Automate SQL Server RESTORE VERIFYONLY Process with Maintenance Tasks MSSQL Tips2006-10-31
SQL Server Database Maintenance Plans and Backup File Management MSSQL Tips2006-10-25
SQL 2000 Database Maintenance Plan vs SQL Server 2005 SSIS Tasks Jeremy Kadlec2006-09-06
Performing maintenance tasks in SQL Server Greg Robidoux2006-07-07