SQL Slayer

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