Month: November 2021

slowest stored procedures

when fulltext is not auto-updating, this query finds the offending tables and selectively updates

finds all databases with no full backup in >7 days, generates the backup commands

example of checking all databases for orphaned users

current trace flags

list all foreign keys, no definition

custom script to update statistics on tables meeting a formula for rows modified.

search all indexes, all databases for an index on a specific table name

searches objects and columns that contian a string, but in all databases.

searches sql_modules for a specific string in the current database