In this article from chapter 2 of SQL Server DMVs in Action, author Ian Stirk discusses a quick method of creating temporary tables, which is needed when we want to loop over all databases on a server, extracting the results as we go.
DMVs are views on SQL Server metadata, which can be used to improve the performance of your SQL queries. In this article, Ian Stirk, author of SQL Server DMVs in Action, describes how DMVs can help fix common SQL issues.