By Adam Bean, on July 8th, 2010
http://www.sqlslayer.com/wp/admin-database/
- Updated MissingIndexes_vw to include support for ONLINE operations (Enterprise Edition). Also added DROP statements.
By Adam Bean, on July 7th, 2010
http://www.sqlslayer.com/wp/admin-database/
- Updated who to resolve collation issues with joining with split_fn.
- Updated DefaultTrace_vw to only pull is_default.
By Adam Bean, on July 1st, 2010
http://www.sqlslayer.com/wp/admin-database/
- Updated several objects to resolve collation issues with joining with split_fn.
By Adam Bean, on June 28th, 2010
http://www.sqlslayer.com/wp/admin-database/
- Fixed duplicate code execution in StandardGroupPermissions when replication was present (all versions).
- Fixed role ownership in StandardGroupPermissions (2005,2008).
By Adam Bean, on June 14th, 2010
http://www.sqlslayer.com/wp/admin-database/
- Fixed job operators to properly update jobs if the job named contained a single quote.
By Adam Bean, on June 1st, 2010
http://www.sqlslayer.com/wp/admin-database/
- Remove contents of Cleanup. Updated Scripts for buildMin on ExecutionPlans_vw.
- Resolved collation issues for 2000 versions of KillProcess, DBReindex, Weekly_DBMaint_CheckDB & Weekly_DBMaint_Reindex.
- Fixed configuration issue with whoLoggedIn_vw.
By Adam Bean, on May 7th, 2010
http://www.sqlslayer.com/wp/admin-database/
- Updated who_vw to use OUTER APPLY vs. CROSS APPLY on dm_exec_sql_text as connections with no query text returned would not show up. Still need to COALESCE the query to return from sysprocesses as sysprocesses will contain the text that dm_exec_sql_text doesn’t. Amazes me how sysprocesses is still required on many different levels.
By Adam Bean, on May 6th, 2010
http://www.sqlslayer.com/wp/admin-database/
- Added new parameter (@MISearch) to 2005+ version of IndexInfo to only retrieve indexes with a prefix of “IX_MI_” which are a result of adding index recommendations from MissingIndexes_vw. Need to write an article about this process, but basically a quick and easy way to add all the missing indexes SQL thinks are required and then to go back and analyze their usefulness.
By Adam Bean, on April 27th, 2010
http://www.sqlslayer.com/wp/admin-database/
- New object ExecutionPlans (2000) added.
- New object ExecutionPlans_vw (2005/2008) added.
- Resolved collation issues with both DBSizeGroup views, 2000 version of DBReindex, and 2000 version of who.
- Several enhancements to BackupDB.
By Adam Bean, on April 21st, 2010
Comments