Top 14 KPI

Get the 14 most used Key Performance Indicators

SQL Server CPU Usage History Histogram

Returns a summary of CPU usage by SQL Server over the last 4 hours (default).

Using the sample values collected in the dm_os_ring_buffers dmv, this query will show CPU usage by the SQL Server process for the last for hours even if you have no other benchmarking activities in place on your server yet.

SQL Job Timeline (Graphical)

This script generates a graphical timeline of all SQL jobs with a variable zoom level

Reindex Procedure with a Twist (or two) the SQL

A 2012 update to "Reindex Procedure with a Twist (or two)":

Get database size, used space, free space

Gets the size, amount of space used & unused, owner and modify date for all databases in a Sql instance.

Deleting Duplicate Records

In Datawarehousing, a normal scenario is eleminating duplicate records/rows or deleting duplicate records, here's the solution.

Dynamic pivoting

Dynamically create and/or execute a pivot sql statement against a provided table.

Physical Server or a Virtual Machine?

Simple T-SQL Script to know whether your SQL Server is running on a Physical box or a VM.
Note: This Script works only on 2008R2 SP1 and above.

Create MERGE statements with data!

A script to create MERGE statements with data for specific tables.

SQL Server Performance Base Line Script

Performance Base Line Report from SQL Server DMVs and Perfmon counters