The non-SSIS/GUI method I use to deploy standardized Database Maintenance Plans.  Read more...

Reports table columns that are not foreign keys but that perhaps should be.  Read more...

Drop indexes no longer being used.  Read more...

This script reports objects that are referenced by and that reference a given database object. When a column name is specified, it also includes results showing how that column is used.  Read more...

A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly  Read more...

This script reports table columns that allow NULL values but that currently have no NULL values, making them candidates for adding a NOT NULL constraint.  Read more...

Just a stab at automating index maintainenance in SQL Server 2008  Read more...

Following code snippet will selectively rebuild indexes that have been thrashed after a big indert  Read more...

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.  Read more...

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...

Script to loop thru multiple linked server and get agent scheduled jobs for the next XX hours.  Read more...

Find missing and mismatched views and stored procs between 2 Databases  Read more...

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...

This is a data quality script that locates unused Database Roles for maintenance purposes  Read more...

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.  Read more...

How to set the database to a single user mode  Read more...

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

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

Script to move physical files to a new location  Read more...

Reports on physical size of tables in your database to identify largest.  Read more...