An interesting and useful question, thanks Steve.
I also thank jschmidt 17654 for sharing a perfect general solution, well done. 🙂

# Create the data frame.
rank <- c(1,2,3,4,5)

Great question, thanks Evgeny. But I'm not sure if parameter SYSTEM_VERSIONING = ON must be specified.
How does it mean in Docs when Creating and System-Versioned Temporal...

Maybe the explanation can be found in paragraph 3) of 5 Things About Fillfactor:

3) Fillfactor doesn’t impact new pages inserted at the end of an index

Thanks for the interesting question Mohammed. Quite hard, but the documentation helped me.
Is it e.g. "5 Things About Fillfactor", and in Docs "ALTER INDEX...

Thanks for this question. A short note to the Explanation, the Docs says that the PERCENT_RANK function returns the data type float.

This documentation from Technet GROUPING SETS Equivalents helped me,
and then experimenting with an example in DOCS GROUPING (Transact-SQL)

SELECT SalesQuota, SUM(SalesYTD) 'TotalSalesYTD', GROUPING(SalesQuota) AS 'Grouping'...

Thanks for this question, let me add a small note that in "mycoolfunction"
is a syntax error in the return function. Syntax of return() is: return(expression).
It should be...

I'm sorry, but the additional fix of the response options is not fair. 😉
Happy New Year!

Hmm... it's not easy, in the DOCS Maximum Capacity Specifications for SQL Server is stated:
"Indexes per memory-optimized table: 999 starting SQL Server 2017 and in Azure SQL Database,...

Thanks for this question. I also learned how SQL Server 2016 memory-optimized tables support off-row storage.
I' ve found that 7 bytes overhead is well described in the 

Thanks for this strange question. I had a bit of fun with this code:

DECLARE @dt1 DATETIME = '2017-10-31',
        @dt2 DATETIME = '2000-01-01',
        @dt_def DATETIME =...

Thanks for this question on an interesting topic. I appreciate the compilation of questions, especially question #5...😉

The use of backslashes in file addressing is very well explained e.g. in R for Microsoft Excel Users
Easier is to use forward slashes: file="c:/nfl/2016qbstats.csv"