DMO Word Scramble

  • Comments posted to this topic are about the item DMO Word Scramble

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

  • I do not know, If I am correct, DMO world Scramble, resulted difficult, instead I searched the keys:
    1.sys.dm_exec_query_stats
    2.sys.dm_exec_requests
    3.sys.dm_exec_text_query_plan
    4.sys.dm_io_virtual_file_stats
    5.sys.dm_os_sys_info
    6.sys.dm_os_waiting_tasks
    7. sys.dm_tran_session_transactions
    8. sys.dm_tran_locks
    9. sys.dm_tran_active_transaction
    10. sys.dm_db_file_space_usage
    :crazy:

  • Sorry for the delay, but here is the answer key 🙂

    1.  SYS.DM_EXEC_CONNECTIONS
    2.  SYS.DM_EXEC_REQUESTS
    3.  SYS.DM_EXEC_TEXT_QUERY_PLAN
    4.  SYS.DM_IO_VIRTUAL_FILE_STATS
    5.  SYS.DM_OS_SYS_INFO
    6.  SYS.DM_OS_WAITING_TASKS
    7.  SYS.DM_TRAN_CURRENT_TRANSACTION
    8.  SYS.DM_TRAN_LOCKS
    9.  SYS.DM_TRAN_SESSION_TRANSACTIONS
    10. SYS.DM_DB_FILE_SPACE_USAGE

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply