The sp_spaceused procedure does not provide schema name in return. Here is sp_spaceused2 that does.  Read more...

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...

This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.  Read more...

This script quick tip for those who will accurately monitor sessions on SQL Server.  Read more...

This script will email info about the longest running SPID in an HTML formatted table  Read more...

This SP will monitor T-Log space and sends mail to DBA if log space usage is above threshold value  Read more...

Report to keep you abreast of various details of an instance, including: general properties, uptime, drive space, db size allocation, growth stats, backups, jobs, unused indexes, & more...  Read more...

Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.  Read more...

This script finds the last run status for Full / TL backups.  Read more...

Track object definition or table schema changes in any database. Batteries required: you need to create a few things to make it run.  Read more...

This scripts helps to power you with the disk space monitoring for the Mount points. Hope this helps  Read more...

Simple T-SQL to find failed SQL Agent jobs  Read more...

The default trace keeps the last 20 meg of info, and a max of 5 files...This loads all 5 files into a table so it can be reviewed.  Read more...

A complete blocking report which gives the complete information about what queries are runninng and it will be worth capturing the details before we decide to kill the processes.  Read more...

Scripts will display size of the data in the database/data files and remaining allocated space.  Read more...

A better way to use sp_spaceused, returning values on one row for the database instead of two.  Read more...

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000  Read more...

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005  Read more...

This select will show the last sql statement for every open session plus many helpfull information.  Read more...