Nice tricky question. It gave me a chance to revisit the data types.

Thank you.

Great question and I have learnt more about NUMA that I had not explored much.

http://msdn.microsoft.com/en-us/library/ms345357.aspx

Thank you.

Interesting topic on Hash Join and again a tricky question in that one could overlook the fact that a unique constraint already does exist in this particular scenario.

Thanks.

Thanks for tough question though I liked it alot since it covers the index topic and always an important concept to grasp.

Thanks for the great question and if one assumed or missed to note on the words 'clustered node' then would have likely flopped submitting the answer for the non-clustered node....

I stand corrected, but my determining factor was the 'DML' keyword. Also eliminated the 'CLR' trigger since applies to DML & DDL yet the question was specific to...

Great question and wonderful url on the covered topic.

Thanks to Steve & Iulian.

Great question on the 'Server-Scoped DDL trigger' that was tricky and needed a better understanding using the tip on of the main question.