20

SQL Server 2019 CTP 2.3 added a few new columns to sys.databases, including is_result_set_caching_on:

sys.databases

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'.
  • 2
    This was mentioned in one of the SQL Bits presentations in the context of polybase I think – Martin Smith Mar 3 at 21:38
  • 4
    You're going to need some windbg skills there, bud. – DBArgenis Mar 4 at 16:30
10

Currently, in CTP 2.3, in so far as I can tell - you cannot enable this, even under DAC.

  • 8
    You can, it's just, uh...I'm... (loosens collar)...looking for someone willing to go on record with it publicly. :-) – Brent Ozar Mar 3 at 18:20
  • 4
    ;) 13 more to go – Sean Gallardy Mar 3 at 18:30

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.