Thank you, Steve, I understand this can happen every once in a while.

Regards,

"El" Jerry.

Hi!!! After thorough reading and searching I found and selected the right answers based on the same referenced article, just to find out they were wrong?

Looks to me that...

I chose yes for a different reason, upon researching I found this article:

http://stackoverflow.com/questions/440944/sql-server-query-fast-but-slow-from-procedure

I didn't think of the implicit conversion but ANSI_NULLS sounded like a reasonable option for index seek.

Has anybody...

Great question. Always something new to learn.

Great question!! Thanks for it. I had to deeply analyze the lock modes and the MSDN articles in order to decide which answer was correct, and that helped me learn...

Confusing question because of #4, but considering all others are correct, #5 would've been the right answer.

Cheers,

GG.

😀

MSDN states (http://msdn.microsoft.com/en-us/library/ms191250.aspx):

"A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant, function, and...

I think I chose the right answer and still got it wrong. Is there a way I can confirm which answer I chose?

Thank you,

GG.

I agree with cengland0 about portability. You never know where your code will end up running, even if it is a secured ("closed"?) environment. As a former Tech Support Analyst,...

I would probably spend all the lottery money in my own real estate business, and make it grow and live out of its profits. I would keep working in my...

[font="Courier New"]

Hi!!!

As far as I understood, the layout of the reindeer pulling the sleigh was something like this:

+------+Dasher--Prancer-Comet--Donner--+

|SLEIGH|...............................>--Rudolph

+------+Dancer--Vixen---Cupid--Blitzen-+

Not sure about the order of the first 8 reindeer, but...

I completely agree with this point. All data is valuable, from huge corporations' to personal, and therefore losing it to the wrong hands unencrypted is not acceptable. Does Microsoft care...

Tom,

In the e-mail newsletter the QotD did not state it was for SQL Server 2008 and later, so I tested under SQL Server 2005 (the only version I...