Sign in
Microsoft.com
 
Microsoft
 
 
 

none
70-461 System Tables RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hey everyone. I am studying for my 70-461 exam and had recently taken a practice exam which had querying system tables (like sys.dm_tran_database_transactions). I am primarily using the toolkit for my studying and while it talks about some of these system tables, it doesn't appear to cover system tables in depth. I was wondering if anyone knew if I should put much focus on this subject, or should i not worry about it? I want to be prepared as much as I can for the exam, and anything I need to know outside of the exam I plan on working on after I pass it. Thanks in advance!
    Thursday, February 19, 2015 6:27 AM
    |

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    sys.dm_tran_database_transactions is actually a Dynamic Management View and not a System Table.

    You will need to know which ones are used to assist with optimizing queries and tables.

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCSE: Data Platform & Business Intelligence
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Thursday, February 19, 2015 6:32 AM
    |
    Moderator