i mean, re-reading them both in a generous light, yea... i think there's a non-zero chance that they could be answers
i strongly suspect both of the answer-posters were just saying "oh yea, i saw this too", but because the OP is kind of vague, it can be interpreted that they're contributing to the list of possible causes of the symptom described
It's not always obvious to me how to improve an answer that's based on the poster's personal experience, even though I may feel strongly that the answer is incomplete.
The problem with both these answers in my opinion is that they would become identical if you improve them. They now list 1 setting that impacts the cachestore. They could be improved by listing all the options and scenarios in which that happens, but then they would basically be the same answer
Now you all go ahead and improve it with reproduction scenarios and code :)
-- close last connection to shut down database
kill xx
-- verify cache flush
SELECT * FROM xp_errorlog;
-- change sp_configure setting
sp_configure 'max degree of parallelism', 0
RECONFIGURE
-- verify cache flush
xp_readerrorlog
Not that it's really a problem for anyone that has faced this syntactic issue before, but I see a wild amount of confusion stemming from the use of the caret (^) as the XOR operation in lieu of the widely accepted mathematical exponentiation operation.
Of course there are a lot of places where t...
@CadeRoux I know, but it works. No, no escapes, only an @ at the beginning and an * at the end
I tried by enclosing it using {}, (according some docs you need brackets if you have leading or ending spaces), but it fails. Then I've tried using @"xxxx" and it worked
@George.Palacios Nothing much to add beyond what Tom and Andriy said
I will just say that for borderline cases, it is often better to raise a custom flag and explain what you want to happen (and why) in the flag text. Mods aren't mind-readers.
For the specific example, it's tough to say which action would be best. Delete? Seems harsh, since it does somewhat answer the question. Convert to comment? Maybe, but comment on which other post? How much of an improvement would that be anyway? Leave it be? Yeah, why not.
Also, at the time the flag was handled, the answer had two upvotes and no downvotes
It also happens if you change "maximum degree of paralelism and cost threshold for parallelism" settings in Instance.
