fn_getfiledetails - a replacement for xp_getfiledetails

As the undocumented SQL Server 2000 function xp_getfiledetails is not existent any more in 2005 or later i needed a replacement...

IsNumber fails cast while IsBigInt passes cast

IsNumber does weak checking and fails cast to BigInt so I wrote IsBigInt to replace it.

A quick way to find recently entered datetime entries in tables

Sometimes you need to scan a large number of datetime columns for most recent access.

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.