SQLServerGeeks.com weekly webcast Quiz (Tue, 21 Feb) - Locking Internals by Amit Bansal

Hi Geeks,

Here is the question from the webcast - (SQLServerGeeks.com weekly webcast Quiz (Tue, 21 Feb) - Locking Internals by Amit Bansal)

Which Trace Flag disables Lock escalation 'completely'?

Option A: 1221

Option B: 1222

Option C: 1223

Option D: 1224

Option E: none of them

Reply to this thread with the right option. Make sure your profile is updated with correct name and address since prizes are going to be sent to those addresses. Quiz closes on Saturday 12 noon IST. Lucky winners will be selected and will be notified on this thread. Here is a small pic of what you are going to get - (DMV poster, SQL sticker, SQL badge holder) - BEST OF LUCK !

Answer is Option E: none of them. Trace flag 1211 completely disables lock escalation.

E . its 1211

1211 so the answer should be E

1211 so the answer should be E

option is E : none of this

Option E: none of them

Option A is the right answer; Trace Flag 1221  disables Lock escalation 'completely'

Answer is Option E: none of them. Trace flag 1211 completely disables lock escalation.

Option E: none of them. Trace Flag 1211 should be used to disable completely

Option E: none of them. Trace Flag 1211 should be used to disable completely

Answer is Option A : 1221

Its option A.  1221

Option E) None of Them

Ans is Flag 1211

 

its Option A: 1221

Option A: 1221

Option A: 1221

Answer is a 1221

Ans: None

Trace flag 1211 to completely disable lock escalation

Answer is Optiion E:none of them

TraceFlag 1211 Disables Lock Escalation compltetely 

If both trace flag 1211 and 1224 are set, 1211 takes precedence over 1224. However, because trace flag 1211 prevents escalation in every case, even under memory pressure.

Hi Geeks,

We thank all the attendees who participated in the webcast quiz - 21 Feb 2012 Tue-Locking Internals by Amit Bansal. The quiz was hosted here: http://www.sqlservergeeks.com/forums/sqlservergeeks-community/announcements/157/sqlservergeeks-com-weekly-webcast-quiz-tue-21-feb-locking-internals-by-amit-bansal

The quiz question was:

Which Trace Flag disables Lock escalation 'completely'?

Option A: 1221

Option B: 1222

Option C: 1223

Option D: 1224

Option E: none of them

The right answer is Option E: none of them. Trace Flag 1211 is the right trace flag which is not listed as an option. Many of you have given the right answer; however only 3 lucky winners are selected as the prize recipients. The 3 lucky winners are:

Ravi Kumar, ChandanPandey & ShanjanSapra.

Congratulations to all the winners!

Winners are requested to send their full address at mamita<at>peoplewareindia<dot>com.

Please note that prizes will be shipped only within India.

We hope our members are enjoying all the community activities that we are conducting. Do continue your participation.

http://www.FaceBook.com/SQLServerGeeks

Regards

http://www.twitter.com/SQLServerGeeks