Find Largest size Tables in a Database

To find a list of Tables (User or System tables)according to their size.

Generate Drop / Create Script for views, stored Procedures

This Script generates drop and create scripts for views or stored procedures.

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.

Show Table, Index and Image/Text size.

This is a simple script that show size from a table and yours related objects.

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