SQL 2005 Disaster Recovery Scripts: To Setup and Remove Mirroring

Two sets of scripts to help setup mirroring or remove mirroring - handy during disaster recovery exercise

Job History with Timeline

Similar to many other Job History scripts, but unique in that it has a timeline.

SQL 2008 MERGE using Dynamic SQL over a Linked Server

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.

usp_PartitionDatabase

Given some input parameters, it generates the filegroups, files, partition function and partition scheme sql statements.

Disk Space Report

This scripts helps to power you with the disk space monitoring for the Mount points.

Hope this helps

Easily delete database objects

The stored procedure sp_DropDatabaseObject is designed to easily drop a variety of database objects with extensive feedback to the user

The Ultimate Running Requests Reporter

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.

Stored Procedure to maintain RSExecutionLog

An alternative to the SSIS approach to maintaining an RSExecutionLog database for Reporting Services supplied by Microsoft

Dynamically script Create Database For Attach For All Databases

Modified version of a script that can be found at http://www.sqlservercentral.com/Contributions/InstallEditor

Table Generator for defined tables

This script will generate a format friendly ddl statement for a predefined table in sql server.