A General Way to Maintain History Tables

You will see here a way to handle history tables. This way only takes into account Date-based data cleanup but is easily generalizable.

Prevent DISK FULL when database grows

Get information to prevent DISK FULL when database grows.

Developing Low-Maintenance Databases

Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.

Total Space Used for all databases per disk

Tells you how much the databases are using the space on disk taking in account the free space at the end of the database.

Auto compression all indexs on all online db

Auto compression of index, if index includes > 1 million rows.

Next grow for all databases per disk

This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.

Automatic Statistics Update Slows Down SQL Server 2005

I have a database which has several tables that have very heavy write operations. These table are very large and some are over a hundred gigabytes. I noticed performance of this database is getting slower and after some investigation we suspect that the Auto Update Statistics function is causing a performance degradation.

Catching errors in DBCC CHECKDB

Shrink Log File to Target Percentage

Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.

Drop user statistics

This procedure drops all manually added statistics (field user_created=1)