The fourth answer is not correct. It is not necessary to install the Microsoft R Server for using R code. See, e.g. this MSDN article Set up SQL Server...

Intuitively I estimated that I got it wrong...:crying: But I found how to check enabled Trace Flags for SQL Server.
On my server I have enabled two global TF 7806...

Thanks for this interesting question, Henrico. Tempdb has default value for ENCRYPTION set to OFF and this setting cannot be modified.
What the documentation doesn't say is what happens...

+1
According to MSDN, AUTO is an option for value of a featured syntax elements... 😉
Thanks Steve for this question.

Interesting question, thanks Steve, to exercise logical reasoning...😉
That a table has INSTEAD OF Trigger can be determined using OBJECTPROPERTY function with Property name 'HasInsteadOfTrigger',
e.g. in the example...

Thanks Steve for this question, yes I had a "Fun with Time", but it cost me just a little time.🙂


DECLARE @t TIME = GETDATE();
SELECT DATEDIFF(MINUTE, 0,...

Thanks Henrico for an interesting question about undocumented DBCC commands.
Clear explanation I found in this blog from Paul White. Interesting is also this Paul Randal's blog.😉

Thanks for this question. I learned something new. I appreciate the Microsoft Azure documentation. 😉

Tough and interesting question, but well specified and after some time, I happily found a good explanation
on MSDN in the...

Thanks for this funny question. An interesting trip into the history of Presidents of the United States. And I had have to brush up the POWER() math function...🙂

Description of the argument <mixed_page_allocation_option> ::= in the MSDN ALTER DATABASE is unhappily worded.
A clear explanation is in the MSDN tempdb Database, paragraph Database Options.