I wish you all a good afternoon.

Answer Query 2 is incorrect because for ADD FILE it is required to enter File option FILENAME.

See syntax checking Query 2: Msg 1036, Level...

Thanks Junior, interesting, but as you can see from the discussion, a bit piquant question.;-)

English is not my native language. So I had translated answer No. 1 that the result...

Thanks Shiva. However I had to translate it twice to Czech. Firstly, what is "Which one of these doesn't match the others?", secondly, what "Who is the odd man out?"....

Thanks Steve. A simple question with unexpected consequences. For me, it was to repeat the lessons about usages of the CONVERT_IMPLICIT functions and the related performance issues.

Thank you for this question. References to this issue opens up wide possibilities for study

issues related to the theme Show Plan.

I was wrong. Evidently I did not read this article carefully:

https://www.simple-talk.com/sql/backup-and-recovery/centralized-management-tips-for-managing-backups-on-multiple-servers/

Thank you for your question , it's new lesson for me and it guided me even to the Selective XML indexes.

Thanks Steve.

I had to once again repeat the DateDiff and DateAdd functions 😉

Merry Christmas 2014 and Happy New Year 2015.

I will get an error like this: Server: Msg 208, Level 16, State 1, Procedure my_sp, Line 2 Invalid object name 'my_table'.