A script that shows you jobs and steps that have succeded or failed recently. (basically, a T-SQL version of your SSMS Job Activity Monitor)  Read more...

Find objects in any database on your SQL instance.  Read more...

Function to split a full file name into drive, path, file name, and extension.  Read more...

I wrote this script to help determine which data files are taking up space on an instance.   Read more...

You can select alphabets alone, Numbers alone, Alphanumeric, or Non Alphanumeric alone.  Read more...

If you get alerts for high CPU, but by the time you login/check the server cpu is back to normal, then use this sp to create a sql agent job and run it every min.  Read more...

Dynamically check your SQL Error Logs and filter using Powershell.  Read more...

Script to help you analyze a trace to find worst performing procs.  Read more...

Query that simulates running sp_spaceused on every applicable object in a database and gathering it all into a single result set.  Read more...

This utility will locate a column across a subset or all databases across a server. Can be configured to run across versions, and can search tables, views or both.  Read more...

Script will give you the list of fragemented indexes. (For SQL 2005-2008)  Read more...

Extract data from XML file from dynamic tag. in this below e.g we can add / remove Escalations tag from xml file. and depends on that result will display.  Read more...

Using EventNotification (Service Broker - DDL_EVENTS) to audit Schema change on a Server, or any of it's databases  Read more...

Create restore script from a SQL Backup file. A must have for your DBA Tool Belt.  Read more...

When you are running a backup or a restore, this script gives you an estimate of completion time.  Read more...

This script will attempt to re-trust untrusted foreign keys and will report counts of successes and failures.  Read more...

Use ROW_NUMBER() to efficiently generate a tally table.  Read more...

Often I've been requested to move a db from one server to another. This script is based on another script I found on the Internet, I cannot remember the name of the Author or track down which site it was.  Read more...

A query to help identify queries that need some tuning.  Read more...

Often when tracking down problems, you need to know if anything has changed recently, this script will tell you...  Read more...