Viewing 15 posts - 1 through 15 (of 47 total)
First, I enjoyed the question. I do not know nearly enough about XQuery, and I have been trying to learn more. Thanks.
Am I the only person that is...
January 27, 2012 at 10:10 am
Good question, which illustrates the importance of defining the maximum data length.
January 26, 2012 at 6:11 am
Great question that shows why salting your hashes is so important.
January 24, 2012 at 8:20 am
Steve Jones - SSC Editor (1/6/2012)
I got it right but I would have gotten it wrong had there been an option that it gets created automatically on sql install.
January 6, 2012 at 1:00 pm
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...
December 5, 2011 at 6:22 am
Great question and great explanation. I can see how this could cause unexpected behavior. I definitely learned something today.
December 5, 2011 at 6:15 am
December 2, 2011 at 7:39 am
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...
November 29, 2011 at 10:48 am
This is a good question, provided the caveats mentioned previously.
November 22, 2011 at 6:17 am
Good question with a good explanation the presents a learning experience for those who got tripped up on either the dates or the BETWEEN.
November 17, 2011 at 6:03 am
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.
November 9, 2011 at 7:30 am
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...
November 9, 2011 at 6:38 am
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,...
November 4, 2011 at 6:25 am
Great question that made me think. Great explanation.
November 1, 2011 at 6:51 am
Great question. I got it right, but only because I have encountered this behavior before, and committed it to memory.
October 17, 2011 at 6:30 am