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 to go back and analyze their usefulness.

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.