Sean,

I'm quite sure the community will agree with me that you deserve the Nobel Patience Prize for your participation in that thread. 🙂

"El" Jerry.

Being close to the USA border helps understanding their culture. Learning English in a Mexico-based USA-cultured institute helps even more.

Got my points, but no practical jokes yesterday since here in...

Friday!!!

"El" Jerry.

Me... about to sign off and go home.

"El" Jerry.

Thanks for the easy question. I also was hesitant at first thinking it was too easy.

Have a nice weekend, everyone.

"El" Jerry.

I think it's OK to strongly discourage the use of 'SELECT *' but resorting to the introduction and whitewashing of bugs to do so is a no-go as far as...

Good question. I had to read a couple articles to understand what it is about, but got the right answer and learned something new about SQL Server 2012.

"El" Jerry.

Good question, but a little more wording on it would have helped understand what "other" means (options for creation, options for containment model, etc.)

"El" Jerry.

Great question. I remember some time ago somebody said about a best practice he had about creating views using "SELECT *", but he had documentation on every database object and...

Thanks for the easy question. Nice way to start the week.

"El" Jerry.

Thank you for the nice and easy question, I agree the article on the link Babu provided would have been more appropriate.

Have an excellent weekend, everyone.

"El" Jerry.

Thanks for the interesting question. Despite the typo, elimination on analyzing all possible answers leads to a single option.

Regarding the typo, besides Hugo's wise words, "to err is human", and...

I overcame a similar situation by mapping a Windows user ID to a credential, then created a proxy account pointing to that credential, and set the job to use the...

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