on SQL Authority
See other posts from SQL Authority
or by pinaldave
Published on Sat, 15 May 2010 01:30:52 +0000 Indexed on 2010/05/15 1:45 UTC
Read the original article Hit count: 796
“How many DMVs and DVFs are there in SQL Server 2008?” – this question was asked to me in one of the recent SQL Server Trainings.
Answer is very simple:
SELECT name, type, type_desc
WHERE name LIKE 'dm_%'
ORDER BY name
Reference: Pinal Dave (http://blog.sqlauthority.com)
Filed under: Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology Tagged: SQL DMV
© SQL Authority or respective owner