Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Question of the Day for 20 Jan 2004 Expand / Collapse
Author
Message
Posted Monday, January 19, 2004 12:05 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
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.
Post #96064
Posted Tuesday, January 20, 2004 12:34 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 6, 2012 8:30 AM
Points: 879, Visits: 810

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

A curious person.




Greetz,
Hans Brouwer
Post #96148
Posted Tuesday, January 20, 2004 2:21 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:18 AM
Points: 5,956, Visits: 285

This one might help

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



--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Post #96153
Posted Tuesday, January 20, 2004 6:21 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 9, 2008 7:12 AM
Points: 492, Visits: 6

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



David
Post #96179
Posted Tuesday, January 20, 2004 7:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 9:28 PM
Points: 1,140, Visits: 702
I searched Google, Deja, BOL, etc, and couldn't find a single hit on "StallReportThreshold" ... Any unofficial documentation on DBCC LOCK available?

--
Adam Machanic
SQL Server MVP
SQLblog.com: THE SQL Server Blog Spot on the Web
Post #96203
Posted Tuesday, January 20, 2004 7:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:18 AM
Points: 5,956, Visits: 285
I haven't found such a documentation. But looking at the article I've mentioned didn't make the answer that difficult anymore.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Post #96206
Posted Tuesday, January 20, 2004 7:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 1, 2005 11:41 AM
Points: 258, Visits: 1

I found this URL with some undocumented DBCC commands.

I does have DBCC LOCK listed.

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

 




What's the business problem you're trying to solve?
Post #96210
Posted Tuesday, January 20, 2004 10:11 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Saturday, January 4, 2014 11:05 PM
Points: 968, Visits: 67

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




Post #96245
Posted Tuesday, January 20, 2004 3:57 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 12, 2007 11:52 PM
Points: 39, Visits: 1

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




Pat Wright
Dba
Post #96322
Posted Wednesday, January 21, 2004 8:02 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, June 6, 2013 4:54 PM
Points: 731, Visits: 420

From Google:

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

There are approximately 130 of  them

 

 

Igor




Post #96410
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse