Viewing 15 posts - 286 through 300 (of 673 total)
Trey Staker (6/15/2011)
Interesting question, if the disk dropped below any of the 1st 3 choices profiler would be my least concern.Got it right by a lucky guess.
This is 10 MB...
June 15, 2011 at 10:04 am
Tom.Thomson (6/15/2011)
The reference to an SQL 2000 BoL page is a bit odd though. SQL 2005, SQL 2008,...
June 15, 2011 at 8:52 am
SQLRNNR (6/10/2011)
GilaMonster (6/10/2011)
SanDroid (6/10/2011)
i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:
This is MCM level material....
June 10, 2011 at 2:59 pm
GilaMonster (6/10/2011)
SanDroid (6/10/2011)
i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:
This is MCM level material. Planning...
June 10, 2011 at 8:28 am
Can you at least post the output of SELECT @@version from each server.
Maybe even sp_configure?
June 10, 2011 at 8:06 am
jcrawf02 (6/10/2011)
SanDroid (6/10/2011)
GilaMonster (6/10/2011)
Let me see if I can find a better...
June 10, 2011 at 8:01 am
GilaMonster (6/10/2011)
You get a lazy writer (and couple other things) per hard NUMA node, not soft. That reference is wrong.Let me see if I can find a better one....
Thanks Gail...
June 10, 2011 at 7:49 am
jcrawf02 (6/10/2011)
Question is missing a response: "ten forum posts" 😛
LOL... Yes it is 😎
June 10, 2011 at 7:45 am
Nice and easy monday question Steve. Thanks again!
Rememered this answer from my first NT certification test.
Was suprised that 50% got it wrong.
June 6, 2011 at 3:02 pm
Damian Widera-396333 (5/30/2011)
Easy 2 pts 🙂
The question was only worth one point.
Did you mean one point for the question and one point for your Forum post?
May 31, 2011 at 8:46 am
Nice Resource Pool question.
I am sure it was not so easy to answer for those that are not familiar. 😉
May 31, 2011 at 8:44 am
Steve Jones - SSC Editor (5/25/2011)
May 25, 2011 at 10:33 am
Tom.Thomson (5/25/2011)
I don't see "partition lock" as a term in there at all. You do understand that there's a difference between having the two words "partition" and "lock" adjacent...
May 25, 2011 at 10:15 am
GilaMonster (5/25/2011)
If the table is partitioned, lock escalation will be allowed to partition. After the lock is escalated to the partition level, the lock will not be escalated later to...
May 25, 2011 at 8:41 am
Viewing 15 posts - 286 through 300 (of 673 total)