Tag

dmv

Looping over Databases on a Server

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.

Looping over Databases on a Server (PDF)

Welcome to the Dynamic Management Views Goldmine

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.

Welcome to the Dynamic Management Views Goldmine (PDF)

© 2022 Manning — Design Credits