SQLServerCentral / Question of the Day (QOD) / Testing Center / Question of the Day for 20 Jan 2004 / Latest Posts

RE: Question of the Day for 20 Jan 2004

L' Eomot Inversé — Sun, 17 Feb 2013 09:33:01 GMT

[quote][b]Jeff W (1/21/2004)[/b][hr]This was a great question!! Good useful stuff!!![/quote]Yes.It's a pity that MS never bothered to document hordes of useful stuff done by various trace flags and lots of useful DBCC commands.

RE: Question of the Day for 20 Jan 2004

Jeff W — Wed, 21 Jan 2004 08:17:00 GMT

This was a great question!! Good useful stuff!!!

RE: Question of the Day for 20 Jan 2004

Igor Raytsin — Wed, 21 Jan 2004 08:02:00 GMT

From Google:

http://www.extremeexperts.com/sql/articles/ListDBCCCommands.aspx

There are approximately 130 of them

Igor

RE: Question of the Day for 20 Jan 2004

pwright7776 — Tue, 20 Jan 2004 15:57:00 GMT

I thought this was pretty tough also since it was an undocumented DBCC. But I luckily guessed the right thing knowing how most of the DBCC commands are worded.

Have a good day!

Pat

RE: Question of the Day for 20 Jan 2004

chrisleonard — Tue, 20 Jan 2004 10:11:00 GMT

I thought this was a really interesting question - and a pretty tough one, too! Google didn't help at all, and the old lists of undocumented DBCC commands don't help, because DBCC LOCK used to not have any parameters.

Responding to AFPeterson's post, this could be very useful ... but I'll PM you so as not to spoil the question for anybody else.

I actually had to test the thing out to figure out what it did exactly. That's probably what made it such an enjoyable question for me - the fact that it was something that I didn't know and couldn't look up in BOL, but I could test it at least. My biggest surprise is that 65 % of people have gotten it right so far! Either this is a nice parameter that I just didn't know about (and 65% of everybody else did!) or it's an easy question to guess, or ... maybe Frank's post helped some people? But I already knew what the 3605 did ...

Cheers,Chris

RE: Question of the Day for 20 Jan 2004

AFPeterson — Tue, 20 Jan 2004 07:54:00 GMT

I found this URL with some undocumented DBCC commands.

I does have DBCC LOCK listed.

http://databasejournal.com/features/mssql/print.php/1459071

RE: Question of the Day for 20 Jan 2004

Frank Kalis — Tue, 20 Jan 2004 07:37:00 GMT

I haven't found such a documentation. But looking at the article I've mentioned didn't make the answer that difficult anymore.

RE: Question of the Day for 20 Jan 2004

Adam Machanic — Tue, 20 Jan 2004 07:32:00 GMT

I searched Google, Deja, BOL, etc, and couldn't find a single hit on "StallReportThreshold" ... Any unofficial documentation on DBCC LOCK available?

RE: Question of the Day for 20 Jan 2004

David S Dudley Jr — Tue, 20 Jan 2004 06:21:00 GMT

Thanks for pointing out the trace flags info.

Just like NewBie...

I can't find the DBCC LOCK command listed

nor can I find the StallReportThreshold option listed anywhere (even on a search on Google)

David

RE: Question of the Day for 20 Jan 2004

Frank Kalis — Tue, 20 Jan 2004 02:21:00 GMT

This one might help

http://www.sqlservercentral.com/columnists/RDyess/traceflags.asp

RE: Question of the Day for 20 Jan 2004

FreeHansje — Tue, 20 Jan 2004 00:34:00 GMT

So, where do I find info on the DBCC LOCK command? Not in BOL, I don't...

A curious person.

Question of the Day for 20 Jan 2004

Site Owners — Mon, 19 Jan 2004 12:05:00 GMT

Comments posted to this topic are about the Question of the Day for 20 Jan 2004 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=164.