Post reply

DBCC COMMANDS

  • October 6, 2011 at 8:32 pm

    #390564

    Comments posted to this topic are about the item DBCC COMMANDS

  • October 6, 2011 at 8:33 pm

    #1391547

    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]

  • October 6, 2011 at 8:56 pm

    #1391551

    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

  • October 6, 2011 at 9:10 pm

    #1391555

    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]

  • October 6, 2011 at 11:03 pm

    #1391562

    Good easy one.

    M&M

  • October 7, 2011 at 12:30 am

    #1391580

    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

  • October 7, 2011 at 12:47 am

    This was removed by the editor as SPAM

  • October 7, 2011 at 1:57 am

    #1391595

    I got it right.

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

    Whcih command shows all the open transactions .?

    Thanks.

  • October 7, 2011 at 3:29 am

    #1391618

    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

  • October 7, 2011 at 5:34 am

    #1391642

    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

  • October 7, 2011 at 6:09 am

    #1391654

    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!

  • October 7, 2011 at 6:19 am

    #1391658

    Great question.

    Thanks,

    Matt

  • October 7, 2011 at 6:28 am

    #1391662

    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]

  • October 7, 2011 at 7:29 am

    #1391705

    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.

  • October 7, 2011 at 8:05 am

    #1391747

    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