SQL Slayer

http://www.sqlslayer.com/wp/admin-database/

Updated MissingIndexes_vw to include support for ONLINE operations (Enterprise Edition). Also added DROP statements.

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.

http://www.sqlslayer.com/wp/admin-database/

Updated several objects to resolve collation issues with joining with split_fn.

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).

http://www.sqlslayer.com/wp/admin-database/

Fixed job operators to properly update jobs if the job named contained a single quote.

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.

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.

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 [...]

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.

http://www.sqlslayer.com/wp/admin-database/

New object (DBExtProps) added.