Reference: http://blog.sqlauthority.com/2009/06/23/sql-server-2005-2008-delete-duplicate-rows/
Category: MSSQL
Find Currently Running Query – T-SQL
Reference: http://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/
Find Most Expensive Queries Using DMV
Reference: http://blog.sqlauthority.com/2010/05/14/sql-server-find-most-expensive-queries-using-dmv/
Get Latest SQL Query for Sessions
Reference: http://blog.sqlauthority.com/2010/05/05/sql-server-get-latest-sql-query-for-sessions-dmv/
Last Read / Last Write
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/
Database Primary Key Max Entry Fix
Two options with this fix, official script from Ektron or to fix the individual tables that are currently having the issue. Individual Table(s) Official fix from Ektron, specific to 8.0.2