First, I enjoyed the question. I do not know nearly enough about XQuery, and I have been trying to learn more. Thanks.

<rant>

Am I the only person that is...

Good question, which illustrates the importance of defining the maximum data length.

Thanks,

Matt

Great question that shows why salting your hashes is so important.

Thanks,

Matt

Steve Jones - SSC Editor (1/6/2012)

I...

I agree fully. TDE should be in all editions of SQL Server. When the media gets wind of stolen data from a SQL Server environment, it is bad...

Great question and great explanation. I can see how this could cause unexpected behavior. I definitely learned something today.

Thanks,

Matt

Great question.

Thanks,

Matt

Good question. Something like this can trip anyone up. I'm sorry that it took a few hours to recognize the mistake, but we have all been there at...

This is a good question, provided the caveats mentioned previously.

Thanks,

Matt

Good question with a good explanation the presents a learning experience for those who got tripped up on either the dates or the BETWEEN.

Thanks,

Matt

At first glance, it appears that Microsoft is getting rid of the most visible advantage they have over Oracle, price point. I really do not like this move.

However, in...

Great question. I got it wrong, because my reading comprehension needs to improve. I saw the foreign keys, the question asked about an index that supports those foreign...

Thanks for the question.

I am not sure I agree that the Witness is not applicable, though. According to Microsoft's documentation, you can setup a witness in High Performance mode,...

Great question that made me think. Great explanation.

Thanks,

Matt

Great question. I got it right, but only because I have encountered this behavior before, and committed it to memory.

Thanks,

Matt