SQL Server 2016 Query Crashes Server
I think I might have a legit answer .. and its a bug.

(similar was found when running checkdb in 2014 &amp; fixed in SP1 + CU1)

When I run the query as is, SQL Server crashes 


  2016-06-16 17:27:32.00 spid37s      Failed allocate pages: FAIL_PAGE_ALLOCATION 1


And in the error log I see :

MEMORYCLERK_SQLQUERYEXEC (node 0)                KB
---------------------------------------- ----------
VM Reserved                                       0
VM Committed                                      0
Locked Pages Allocated                            0
SM Reserved                                       0
SM Committed                                      0
Pages Allocated                            10678248  ==&gt; 10GB !!
2016-06-16 17:27:32.00 spid37s     


With OPTION (MAXDOP 1) => serial execution

MEMORYCLERK_SQLQUERYEXEC (node 0)        KB
---------------------------------------- -----------
VM Reserved                              0
VM Committed                             0
Locked Pages Allocated                   0
SM Reserved                              0
SM Committed                             0
Pages Allocated                          144


Please test it in your environment and let me know.