SQL Slayer

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.

We are very excited to finally release our first “official” release of the admin database objects. While we are still not yet ready for the documentation (shocking, I know), the objects have gone through a fair amount of testing and we’re confident that your environment is ready to utilize them. Lots of new changes and some new objects since the last RC deployment.

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

Enjoy!