Thanks for this question Steve. I repeated the conversion time to datetime2...:ermm:
For the result to 1900-01-01 10:00:00.000 should be in the code specified DECLARE @t DATETIME2(3) = '10:00...

Maybe that's wrong I understand, but it feels like a belated April Fools prank...😉

The syntax CREATE PROCEDURE statement allows you to create output_only procedure. The following stored procedure has only one output parameter.
For this reason, I could not choose the correct...

Thanks Steve for this question, but above all for the perfect link. I learned something new. 🙂

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