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.

View connection and Locking Information

This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address

Change Monitor in SQL Server 2005

Track object definition or table schema changes in any database. Batteries required: you need to create a few things to make it run.