Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.
2011-04-21 (first published: 2009-09-03)
Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000
2008-07-11 (first published: 2008-06-03)
Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005
2011-12-19 (first published: 2008-06-03)
This select will show the last sql statement for every open session plus many helpfull information.
2012-01-13 (first published: 2008-03-04)