How do you enable SQL Server 2019's result set caching? SQL Server 2019 CTP 2.3 added a few new columns to sys.databases, including is_result_set_caching_on:



It's not documented yet in the What's New in SQL Server 2019, nor in the ALTER DATABASE page.

I tried using the same syntax as Accelerated Database Recovery just for laughs:

ALTER DATABASE StackOverflow2013 SET RESULT_SET_CACHING ON;


But no luck:

Msg 5058, Level 16, State 12, Line 8
Option 'RESULT_SET_CACHING' cannot be set in database 'StackOverflow2013'.
Currently, in CTP 2.3, in so far as I can tell - you cannot enable this, even under DAC.