Forcing Plans in the Query Store

Question

Post reply

Forcing Plans in the Query Store

Steve Jones - SSC Editor

SSC Guru

Points: 736494
More actions
April 7, 2016 at 8:58 pm

#74536

Comments posted to this topic are about the item Forcing Plans in the Query Store
April 8, 2016 at 12:50 am

This was removed by the editor as SPAM

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

HappyGeek SSCoach Points: 18729 More actions · Answer 1

HappyGeek

SSCoach

Points: 18729

April 7, 2016 at 11:51 pm

#1870706

Good question thanks.

...

paul s-306273 SSChampion Points: 10730 More actions · Answer 2

paul s-306273

SSChampion

Points: 10730

April 8, 2016 at 4:43 am

#1870744

New to me.

Thanks Steve.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

I had to look it up because I've not gotten to play with the shiny new toys yet. Thanks, Steve.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

TomThomson SSC Guru Points: 104773 More actions · Answer 4

Ed Wagner (4/8/2016)
I had to look it up because I've not gotten to play with the shiny new toys yet. Thanks, Steve.

Me too. It's good to see questions on this new stuff.

Tom

George Vobr SSChampion Points: 10010 More actions · Answer 5

New and interesting , thanks for this question Steve.

daniel.plocinik Hall of Fame Points: 3288 More actions · Answer 6

daniel.plocinik

Hall of Fame

Points: 3288

April 8, 2016 at 6:48 am

#1870774

Very helpful - thanks

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 7

An interesting question about a topic I have not used for the moment ( I can use Azure but I had no time to study it ). Despite this fact , I am curious and I have had a look at system procedures beginning by sys.query_store and I have discovered that only query_plan and query_id are the only both columns existing on all these system procedures ( maybe the documentation has changed since this study time ). I got 1 point but I am thinking that I was lucky....

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 8

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 9

akljfhnlaflkj

SSC Guru

Points: 76202

April 11, 2016 at 7:04 am

#1871121

paul s-306273 (4/8/2016)
New to me.

Same here.

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 10

yes , nice question

Last week I think there was a topic on parallel queries , now this Query Store. Really nice.

Is there a way to make a sandbox to test Query Store ?

T.a.

Iulian

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 11

Iulian -207023 (4/14/2016)
yes , nice question
Last week I think there was a topic on parallel queries , now this Query Store. Really nice.
Is there a way to make a sandbox to test Query Store ?
T.a.
Iulian

Azure, VM, many ways

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 12

Thanks Steve, I will give it a try from here: https://azure.microsoft.com/en-us/free/