Good question that was straight forward to figure out.

Thanks.

Interesting question and took quite sometime to figure out and also learnt along the way.

Thank you.

I expected an error would be thrown due to the extra comma in the table creation, hence causing the SQL statement to fail.

Thanks.

That was a tricky question and yet the answer was right there if one paid close attention. Thanks for the question and I have learnt something else new today.

Thanks.

Thanks for the great question on the MERGE Statement.

Thanks for the great question on the MERGE Statement.

Hi,

It seems that only the db_owner or the db_ddladmin may be able to achieve what you need to achieve per my understanding of your question. See below URL and...

Great question that perfectly helps demo on improving performance by use of already existing system statistics hence avoiding much strain and unnecessary use of system resources to gather the statistics.

Thank...

Great pick on the question. I did have not dealt much with the Service Broker but have now learnt about it.

Thank you.

Great question on the stored procedure.

Thanks. 🙂

Thanks for the question on the data types.

Great question and I have learnt more on 'OVER Clause' that I had not taken used much.

Thank you.

Great question on the DATETIME2 that supports larger precision times and date ranges.

Thanks.

I liked your question and again got a chance to revisit the topic and reminded on the possibility of a threat allowing unauthorized access if data backups were not properly...

Thanks for the question. It's important to understand such basics and was a straight foward question too.