Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...
"What was this column used for again?"—When managing a database with multiple people, it is not uncommon to encounter columns whose meaning is unclear unless you refer back to the table definition ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results