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, ...
The information you need is sometimes split across multiple tables in the database. In the fortune500 data, industry contains some missing values. Use coalesce() to use the value of sector as the ...