Geeks With Blogs

News

The Wrecking Bawl Destructuring query language, one keyword at a time.
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
Requesting Gravatar...
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
Requesting Gravatar...
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
Requesting Gravatar...
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
Requesting Gravatar...
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
Requesting Gravatar...
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
Requesting Gravatar...
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
Requesting Gravatar...
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
Requesting Gravatar...
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

Your comment:
 (will show your gravatar)


Copyright © Alex Bransky | Powered by: GeeksWithBlogs.net