Category: MSSQL – Audit

Reference: http://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/

Reference: http://blog.sqlauthority.com/2010/05/14/sql-server-find-most-expensive-queries-using-dmv/

Reference: http://blog.sqlauthority.com/2010/05/05/sql-server-get-latest-sql-query-for-sessions-dmv/

Sometimes you need to know the last time a table or database was read from or written to, this code will help determine that for you. Originally Found At: http://blog.sqlauthority.com/2009/05/09/sql-server-find-last-date-time-updated-for-any-table/

An extension of Table/View Column Information In the event that you need to find a table that has a specific column name.

Similar to MySQL – Table/View Column Information, this post will help with MSSQL tables and columns. Cleaner Result: All Tables Result: