Query all objects created or modified after specified date

This script will query across all databases, returning a result of objects recently created or modified.

Manipulate Horizontal Hierarchy with UNPIVOT

Convert Horizontal Hierarchy
to vertical Hierarchy.

Update Trigger to Store Only Updated Column and Former Value

History table needs individual rows for each column that has been updated, i.e., a column history.

Overview data from all tables

Updated script to gather overview data from all tables

Report Server Report Usage

Get information about how often, how fast your reports run and how big they are.

Find Single use plans in Plan Cache

This script will return all the Adhoc Single use Plans currently in your Plan Cache.

It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008

Backup All Databases

this script helps you to backup from all database except of sysDatabases

Get Scheduled Jobs from Multiple Servers

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

Get space used by queries in tempdb

See what is taking up space in tempdb.

Dependencies View 2008

Provides a list of dependencies for a stored procedure