Thank you for the question, I investigated a little and got it right.

Even though I still don't use cache transforms in SSIS, it's good to know this just in case...

Thank you for the question. It also made me dig into BOL and scratch my head understanding UNIONs and precedence.

"El" Jerry.

Nice and easy, but still got me thinking a little bit 🙂

@hugo, thank you for the explanation, clear and concise.

"El" Jerry.

Thanks Steve, nice and easy one. I had to dig into documentation to remember if BETWEEN included endpoints or not.

"El" Jerry.

Tough question for those of us who don't have experience on this area. I didn't understand quite well the code, nor the papers I found, so i had to basically...

Thanks for the question, made me think and research for a while.

To me the explanation was clear. When stating

s.Statuses NOT IN (null, 'Idle')

you are trying to compare a data...

Thank you for the question!!

I agree with all others that having at least one numeric causes implicit conversion for the char values, but 2 chars cannot be multiplied.

Yes, we have...

Nice and easy one. Yes, i thought it was a deja vu, but slow reading showed MOST instead of least.

Greetings,

"El" Jerry.

Great question!!! Learned something new today.

"El" Jerry.

Thank you for the easy one.

As far as I know, collation is in part used for handling string literals, isn't it? It shouldn't affect syntax.

------------

A watt of Ottawa.

"El" Jerry.

Nice and easy. As someone said before, it's good to go back to the basics.

In your experience, how often have you seen DBs with Bulk-Logged recovery models and what are...

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">

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...

Great question. Always something new to learn.