Got it wrong this time because I thought the date string would not be explicitly converted, I think I will run the following statement in my mind:

USE SQLSERVER2008R2

SET ALWAYS_EXPLICIT_CONVERSION ON

GO

Though...

Thanks for the question, Ron.

As far as I understand every T-SQL statement takes up database space, even if minimal. I suppose Ron meant by "minimal space" the space it takes...

Thanks for the question, made me think a little because of the code being within a TRANsaction.

My opinion is that the code was created with looping logic code in mind,...

Thanks for the question, even though I don't use it, as I like to say, you never know when you will need it.

"El" Jerry.

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