DBCC COMMANDS

Question

Post reply

DBCC COMMANDS

Arjun SreeVastsva

SSCertifiable

Points: 7150
More actions
October 6, 2011 at 8:32 pm

#390564

Comments posted to this topic are about the item DBCC COMMANDS
October 7, 2011 at 12:47 am

This was removed by the editor as SPAM

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

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

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]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

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]

M&M SSC-Insane Points: 21700 More actions · Answer 4

M&M

SSC-Insane

Points: 21700

October 6, 2011 at 11:03 pm

#1391562

Good easy one.

M&M

Stuart Davies SSCoach Points: 19505 More actions · Answer 5

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

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 6

I got it right.

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

Whcih command shows all the open transactions .?

Thanks.

honza.mf SSCertifiable Points: 5519 More actions · Answer 7

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

Andre Guerreiro SSCertifiable Points: 7319 More actions · Answer 8

Nice question.

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

Thank you.

Best regards,

Andre Guerreiro Neto

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

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 9

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!

Mattrick Ten Centuries Points: 1176 More actions · Answer 10

Mattrick

Ten Centuries

Points: 1176

October 7, 2011 at 6:19 am

#1391658

Great question.

Thanks,

Matt

Ron McCullough SSC Guru Points: 63877 More actions · Answer 11

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]

chrisfradenburg SSCrazy Eights Points: 9592 More actions · Answer 12

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.

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 13

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

http://brittcluff.blogspot.com/

DBCC COMMANDS

Cookies on SQLServerCentral