Queries which include DMFs return a syntax error
When I execute
queries which include DMFs the queries return a syntax error.
For
example:
SELECT -- TOP 20
qs.sql_handle,
qs.execution_count,
qs.total_worker_time [Read Full Article]
Search Results
Search found 4 results on 1 pages for 'dmfs'.
Page 1/1 | 1
-
-
24 Hours of PASS: 15 Powerful Dynamic Management Objects - Deck and Demos
- by Adam Machanic
Thank you to everyone who attended today's 24 Hours of PASS webcast on Dynamic Management Objects! I was shocked, awed, and somewhat scared when I saw the attendee number peak at over 800. I really appreciate your taking time out of your day to listen to me talk. It's always interesting presenting to people I can't see or hear, so I relied on Twitter for a form of nearly real-time feedback. I would like to especially thank everyone who left me tweets both during and after the presentation. Your feedback...(read more)Read the article
-
24 Hours of PASS: 15 Powerful Dynamic Management Objects - Deck and Demos
- by Adam Machanic
Thank you to everyone who attended today's 24 Hours of PASS webcast on Dynamic Management Objects! I was shocked, awed, and somewhat scared when I saw the attendee number peak at over 800. I really appreciate your taking time out of your day to listen to me talk. It's always interesting presenting to people I can't see or hear, so I relied on Twitter for a form of nearly real-time feedback. I would like to especially thank everyone who left me tweets both during and after the presentation. Your feedback...(read more)Read the article
-
Which of Your Stored Procedures are Using the Most Resources?
Dynamic Management Views and Functions aren't always easy to understand. However, they are the easiest way of finding out which of your stored procedures are using up the most resources. Greg takes the time to explain how and why these DMVs and DMFs get their information. Suddenly, it all gets clearer. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL boost to any DBA lucky enough to use it." Jonathan Allen. Download a free trial now.Read the article
