creating a t-sql script to enable query store and auto tuning for each user database

Geeks With Blogs

The Wrecking Bawl Destructuring query language, one keyword at a time.

<< sql server won't start as clustered resource after service pack upgrade | Home | importing ssis flat files in redshift using copy >>

creating a t-sql script to enable query store and auto tuning for each user database

Comments (18) | Share

select 'ALTER DATABASE [' + name + '] SET QUERY_STORE = ON ALTER DATABASE [' + name + '] SET AUTOMATIC_TUNING ( FORCE_LAST_GOOD_PLAN = ON )'

from sys.databases

where name not in ('master','model','msdb','tempdb')

Posted on Tuesday, December 12, 2017 5:02 AM all tech stuff , SQL Server | Back to top

Comments on this post: creating a t-sql script to enable query store and auto tuning for each user database

# re: creating a t-sql script to enable query store and auto tuning for each user database

thanks for sharing this and after reading this i have manipulated in may website and it is working fine

Left by asha on Dec 28, 2017 3:01 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

Wow! This could be one of the most useful blogs we have ever come across on thesubject. Actually excellent info! I’m also an expert in this topic so I can understand your effort. casino bonuslari

Left by Robinjack on Jan 14, 2018 6:46 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

That is truly decent to listen. much obliged to you for the upgrade and good fortunes. blackjack oyna

Left by Robinjack on Jan 14, 2018 6:47 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

Only a grinning visitant here to share the adoration (:, btw exceptional style. bets10 mobil bahis

Left by Robinjack on Jan 15, 2018 2:49 AM

# re: creating a t-sql script to enable query store and auto tuning for each user database

Interesting topic for a blog. I have been searching the Internet for fun and came upon your website. Fabulous post. Thanks a ton for sharing your knowledge! It is great to see that some people still put in an effort into managing their websites. I'll be sure to check back again real soon. click reference

Left by Robinjack on Jan 16, 2018 8:00 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

I truly cherished perusing your online journal. It was extremely very much wrote and simple to undertand. Dissimilar to extra online journals I have perused which are truly not tht great. I likewise discovered your posts extremely fascinating. Truth be told in the wake of understanding, I needed to go demonstrat to it to my companion and he ejoyed it too! bahis

Left by Robinjack on Jan 18, 2018 9:52 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

A debt of gratitude is in order for sharing this helpful information.. klasbahis

Left by Robinjack on Jan 20, 2018 6:06 AM

# re: creating a t-sql script to enable query store and auto tuning for each user database

Fascinating point for an online journal. I have been looking the Internet for no particular reason and happened upon your site. Impressive post. Much appreciated a ton for sharing your insight! It is awesome to see that a few individuals still invest an exertion into dealing with their sites. I'll make certain to inquire again genuine soon. Doctors Tips Online

Left by Robinjack on Jan 21, 2018 6:08 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

It was thinking about whether I could utilize this review on my other site, I will connect it back to your site though.Great Thanks. bedava kumar siteleri

Left by Robinjack on Jan 24, 2018 6:14 AM

# re: creating a t-sql script to enable query store and auto tuning for each user database

This is my first time i visit here. I discovered such a large number of fascinating stuff in your online journal particularly its dialog. From the huge amounts of remarks on your articles, I figure I am by all account not the only one having all the satisfaction here! keep doing awesome educationdetailsonline.com

Left by Robinjack on Jan 31, 2018 7:13 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

This is only the data I am discovering all around. A debt of gratitude is in order for your website, I simply subscribe your web journal. This is a decent blog.. marketing

Left by Robinjack on Feb 13, 2018 7:07 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

Just try to specify ones substance can be as mind blowing. This clarity with your post is radiant and that i may believe you"re a master for this issue. High caliber alongside your agree grant me to grab your present provide for keep changed by utilizing drawing nearer blog entry. You rock several alongside you ought to go on the pleasurable take care of business. http://onlinegameshere.com/

Left by Robinjack on Feb 28, 2018 10:37 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

I am extremely glad to find your post as it will get to be on top in my accumulation of most loved online journals to visit. About Tech Info

Left by Robinjack on Feb 28, 2018 10:37 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

A debt of gratitude is in order for sharing this data. I truly like your blog entry all that much. You have truly shared a useful and intriguing blog entry with individuals.. techsmarthere.com

Left by Robinjack on Feb 28, 2018 10:37 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

A debt of gratitude is in order for sharing this helpful information.. http://healthsolutionsforall.com/

Left by Robinjack on Feb 28, 2018 10:38 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

This is an incredible moving article.I am essentially satisfied with your great work.You put truly extremely accommodating data... Electronis

Left by Robinjack on Feb 28, 2018 10:43 PM

# re: creating a t-sql script to enable query store and auto tuning for each user database

Fabulous site you have here, so much cool data!.. where to buy synthetic cannabinoid spray

Left by Jerimiah Tamia on Mar 17, 2018 6:39 AM

# re: creating a t-sql script to enable query store and auto tuning for each user database

Thank you had sharing with everyone. Can you help me, when i has losed password admin website, i can get pass from database ? and how do get pass with line access. my site dang ky bong88

Left by find password admin by datatbase on Mar 18, 2018 7:12 PM

Your comment:

Title:

Name:

Email: (never displayed) (will show your gravatar)

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Verification:

Code Monkey Projectiles - Index

ASP.Net SQL Server Apple Google SharePoint Windows Visual Studio Team Foundation Server Agile Office Design Patterns Web Azure