DBCC COMMANDS

  • Comments posted to this topic are about the item DBCC COMMANDS

  • NIce question to end the week ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • So far so good - everybody has answered correctly thus far. 6/6

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR (10/6/2011)


    So far so good - everybody has answered correctly thus far. 6/6

    And better yet, no one whining and whimpering about "gimme my points". So far a nice way to end the week

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Good easy one.

    M&M

  • bitbucket-25253 (10/6/2011)


    SQLRNNR (10/6/2011)


    So far so good - everybody has answered correctly thus far. 6/6

    And better yet, no one whining and whimpering about "gimme my points". So far a nice way to end the week

    Agree nice straight forwards question to ease you to the weekend, sadly the percentage correct has now gone downhill - 88% right

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • This was removed by the editor as SPAM

  • I got it right.

    Infact I was under the impression that it shows all the opentransactions....

    Whcih command shows all the open transactions .?

    Thanks.

  • bitbucket-25253 (10/6/2011)


    And better yet, no one whining and whimpering about "gimme my points".

    Don't you miss it? And even no complaints on wording and explanation. :hehe:



    See, understand, learn, try, use efficient
    © Dr.Plch

  • Nice question.

    I thought there was a catch somewhere but there wasn't. 😀

    Thank you.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • good question!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • Great question.

    Thanks,

    Matt

  • honza.mf (10/7/2011)


    bitbucket-25253 (10/6/2011)


    And better yet, no one whining and whimpering about "gimme my points".

    Don't you miss it? And even no complaints on wording and explanation. :hehe:

    Don't I miss it? Heck NO !

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Joy Smith San (10/7/2011)


    Which command shows all the open transactions?

    sys.dm_tran_active_transactions will. I'm not aware of a way to get the statement from that but by looking at the sys.dm_tran_loks you'll be able to see what objects the tran is locking. Maybe someone else knows how to get the statement for the transaction.

  • Nice easy question. I was afraid it was a trick question, but thankfully it wasn't.

    http://brittcluff.blogspot.com/

Viewing 15 posts - 1 through 15 (of 22 total)

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