You'll want to go thru the SCOM Management Pack for SQL guide and probably configure a 'run as' profile.  (And you can configure that profile to only be distributed...

I didn't. And after a few hundred "Incorrect...

Fresh install on Windows 2012 R2, building new cluster, default instance, it's taking several minutes between screen during the Install... starting when it asked for credentials. I did see...

*sigh* Add my voice to the multitude who reiterate definitively that only the ORDER BY guarantees achieving the desired result. :ermm: Tossing indexes on the table hoping...

Picked four as well because of a performance blog I read years ago[/url], and the number four stuck in my head. Sounds like the correct answer is a special...

This question will be fun for the poor soul who attempts to answer the question in 2017 and tries to guess what might have been considered 'current' way back in...

Thomas Abraham (7/4/2013)

---

Thanks for the question Steve. However, in the spirit of harmonic international relations, I propose that we extend the same courtesy to other countries: August 1st for Switzerland,...

And just to add a link 'cause I didn't see one in the answer, and because I couldn't remember if Keywords were blue, or system tables... here's the SQL 2008...

omg. This made my day! Thank you. When I get home tonight,...

(from the question today)

> [...]triggers Lock Escalation (i.e. Row lock to Page level lock)

This would seem to refer to an event that sets off the mental alarms...

(from the reference)

> The...

*scratches head* >The highest quantity sold to any custid is 50

A72

B47

C56

D30

??

zerko (4/28/2013)

---

Tom, yes I noted the deprecation issue - it's not that ...

Question says "Which of the following hints require the word WITH? (choose 3) "

Explanation says "table hints...

Actually I'd argue that it's still an excellent question, and certainly promoted learning. The only issue was a 'distractor' that was actually more correct than the intended correct answer....

mbova407 (3/12/2013)

---

First, Like others have said the question is subjective.

Second, The answer of "Dates which get matched will be returned" is always correct because that is what an inner...

Yes....