Open Transaction details

sql server blocking, open transaction

Calculate relative time

dynamically calculates a timestamp

Get Server version Info

Yet another Script To get Sql server version Info. Run From Central Management server to get all your environment servers

PoSh: Get-WhoInstallSQL

Useful function that finds who installed SQL Server

Show solving arithmetic expression step by step

A script to show how to solve arithmetic expressions step-by-step, for my 9-year old daughter.

Document the output of all the SPs in HTML fashion

A script to document the output columns of all the SPs in a given database, with a HTML formatted document

Open transactions on a database

This script will show you all open transactions from any query windows.

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