How do you enable SQL Server 2019's result set caching?Changing a column's data type fills the transaction...
How to push a box with physics engine by another object?
For Loop and Sum
Wanted: 5.25 floppy to usb adapter
Finding an integral using a table?
Do my Windows system binaries contain sensitive information?
Sometimes a banana is just a banana
Why do members of Congress in committee hearings ask witnesses the same question multiple times?
Why is this code uniquely decodable?
Is Draco canonically good-looking?
Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?
Counting monomials in skew-symmetric+diagonal matrices
Quenching swords in dragon blood; why?
How to acknowledge an embarrassing job interview, now that I work directly with the interviewer?
Avoiding morning and evening handshakes
How would an AI self awareness kill switch work?
Is it a fallacy if someone claims they need an explanation for every word of your argument to the point where they don't understand common terms?
How to satisfy a player character's curiosity about another player character?
Where is this triangular-shaped space station from?
What to do when being responsible for data protection in your lab, yet advice is ignored?
Finding ratio of the area of triangles
Why do neural networks need so many training examples to perform?
Which aircraft had such a luxurious-looking navigator's station?
Inventor that creates machine that grabs man from future
What is Crew Dragon approaching in this picture?
How do you enable SQL Server 2019's result set caching?
Changing a column's data type fills the transaction logSQL Server DB restore failsSQL Server 2008 RestoreHow to restore SQL Server database with mirroringSQL Server consistency I/O base errorDatabase existence not happened correctlyms sql database in suspect mode when we upgrade from developer to standard editionQuery With Date RangesEnable query store for all databases2 SQL 2019 Servers with High Availability Linux with a shared Linux SQL Express 2019 Witness
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'.
sql-server sql-server-2019
asked 17 hours ago
Brent OzarBrent Ozar
35.1k19105240
add a comment |
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'.
sql-server sql-server-2019
asked 17 hours ago
Brent OzarBrent Ozar
35.1k19105240
1
This was mentioned in one of the SQL Bits presentations in the context of polybase I think
– Martin Smith
8 hours ago
add a comment |
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'.
sql-server sql-server-2019
asked 17 hours ago
Brent OzarBrent Ozar
35.1k19105240
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'.
sql-server sql-server-2019
sql-server sql-server-2019
asked 17 hours ago
Brent OzarBrent Ozar
35.1k19105240
asked 17 hours ago
Brent OzarBrent Ozar
35.1k19105240
edited 15 hours ago
Brent Ozar
asked 17 hours ago
Brent OzarBrent Ozar
35.1k19105240
asked 17 hours ago
Brent OzarBrent Ozar
35.1k19105240
asked 17 hours ago
Brent OzarBrent Ozar
35.1k19105240
35.1k19105240
1
This was mentioned in one of the SQL Bits presentations in the context of polybase I think
– Martin Smith
8 hours ago
add a comment |
1
This was mentioned in one of the SQL Bits presentations in the context of polybase I think
– Martin Smith
8 hours ago
1
1
This was mentioned in one of the SQL Bits presentations in the context of polybase I think
– Martin Smith
8 hours ago
This was mentioned in one of the SQL Bits presentations in the context of polybase I think
– Martin Smith
8 hours ago
add a comment |
1 Answer
1
active
oldest
votes
Currently, in CTP 2.3, in so far as I can tell - you cannot enable this, even under DAC.
answered 12 hours ago
Sean GallardySean Gallardy
16.6k22653
4
You can, it's just, uh...I'm... (loosens collar)...looking for someone willing to go on record with it publicly. :-)
– Brent Ozar
11 hours ago
1
;) 13 more to go
– Sean Gallardy
11 hours ago
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f231167%2fhow-do-you-enable-sql-server-2019s-result-set-caching%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Currently, in CTP 2.3, in so far as I can tell - you cannot enable this, even under DAC.
answered 12 hours ago
Sean GallardySean Gallardy
16.6k22653
4
You can, it's just, uh...I'm... (loosens collar)...looking for someone willing to go on record with it publicly. :-)
– Brent Ozar
11 hours ago
1
;) 13 more to go
– Sean Gallardy
11 hours ago
add a comment |
Currently, in CTP 2.3, in so far as I can tell - you cannot enable this, even under DAC.
answered 12 hours ago
Sean GallardySean Gallardy
16.6k22653
4
You can, it's just, uh...I'm... (loosens collar)...looking for someone willing to go on record with it publicly. :-)
– Brent Ozar
11 hours ago
1
;) 13 more to go
– Sean Gallardy
11 hours ago
add a comment |
Currently, in CTP 2.3, in so far as I can tell - you cannot enable this, even under DAC.
answered 12 hours ago
Sean GallardySean Gallardy
16.6k22653
Currently, in CTP 2.3, in so far as I can tell - you cannot enable this, even under DAC.
answered 12 hours ago
Sean GallardySean Gallardy
16.6k22653
answered 12 hours ago
Sean GallardySean Gallardy
16.6k22653
answered 12 hours ago
Sean GallardySean Gallardy
16.6k22653
answered 12 hours ago
Sean GallardySean Gallardy
16.6k22653
16.6k22653
4
You can, it's just, uh...I'm... (loosens collar)...looking for someone willing to go on record with it publicly. :-)
– Brent Ozar
11 hours ago
1
;) 13 more to go
– Sean Gallardy
11 hours ago
add a comment |
4
You can, it's just, uh...I'm... (loosens collar)...looking for someone willing to go on record with it publicly. :-)
– Brent Ozar
11 hours ago
1
;) 13 more to go
– Sean Gallardy
11 hours ago
4
4
You can, it's just, uh...I'm... (loosens collar)...looking for someone willing to go on record with it publicly. :-)
– Brent Ozar
11 hours ago
You can, it's just, uh...I'm... (loosens collar)...looking for someone willing to go on record with it publicly. :-)
– Brent Ozar
11 hours ago
1
1
;) 13 more to go
– Sean Gallardy
11 hours ago
;) 13 more to go
– Sean Gallardy
11 hours ago
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f231167%2fhow-do-you-enable-sql-server-2019s-result-set-caching%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
This was mentioned in one of the SQL Bits presentations in the context of polybase I think
– Martin Smith
8 hours ago