October 6, 2011 at 8:32 pm
Comments posted to this topic are about the item DBCC COMMANDS
October 6, 2011 at 8:33 pm
October 6, 2011 at 8:56 pm
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
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
October 6, 2011 at 11:03 pm
Good easy one.
M&M
October 7, 2011 at 12:30 am
bitbucket-25253 (10/6/2011)
SQLRNNR (10/6/2011)
So far so good - everybody has answered correctly thus far. 6/6And 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
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
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:
October 7, 2011 at 5:34 am
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
good question!
October 7, 2011 at 6:19 am
Great question.
Thanks,
Matt
October 7, 2011 at 6:28 am
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 !
October 7, 2011 at 7:29 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy