Blog is a collection of misc troubleshooting tips collected while supporting Microsoft SQL Server 2000 2005 and 2008 customers.
Forcus area covered include SSIS, Performance, and Replication
Browse by Tags
All Tags »
SQL DMV (RSS)
Sorry, but there are no more tags available to filter with.
-
I don't always remember names of the SQL Server Dynamic Managment views. Books Online is great, but here is a simple query to get a list of DMVs SELECT * FROM sys . all_objects WHERE [name] LIKE '%dm_%' AND [type] IN ( 'V' , 'TF' , 'IF' ) AND [schema_id] Read More...
|