slowest stored procedures
Month: November 2021
envfulltext
when fulltext is not auto-updating, this query finds the offending tables and selectively updates
envfullbak
finds all databases with no full backup in >7 days, generates the backup commands
envforeach
example of checking all databases for orphaned users
envflags
current trace flags
envfks
list all foreign keys, no definition
envfixstats
custom script to update statistics on tables meeting a formula for rows modified.
envfindindex
search all indexes, all databases for an index on a specific table name
envfindglobal
searches objects and columns that contian a string, but in all databases.
envfinddev
searches sql_modules for a specific string in the current database