Query Store is not overwritten during a restore. In fact, it remains completely intact. All Query Store information is in system tables, stored with each database and will get backed...

Piling on.

Sounds like statistics are getting out of date. Focus there, not on index rebuilds (although, those will also update statistics).

ALL cases.

All of them. Statistics are what the optimizer uses to determine how many rows are likely to be returned from a given table or index. Without statistics, the optimizer...

You could provide them with PowerShell commands that run the script. Or, assuming they have a client tool installed, a batch file to run the command. I'd lean towards Powershell....

Check all the settings as suggested. Maybe an application server is misconfigured and using different ANSI settings. Look at the query_hash values to make sure they're the same. Normal behavior,...

Woof!

So, your parameters don't match the data types of the columns. I know you said you can't change the code, but it's wrong. For example, tinyint, which is what's in...

This is an old article, but it shows one way to deal with versioned and backdated data. It's still very applicable. Also a follow-up article showing another mechanism....

A DELETE operation has to find the appropriate rows to delete. That means it has to look at the values. If there are no indexes, it has to scan every...

Oh, and 2019 introduces a bunch of good knobs for tweaking QS behaviors. You really can reduce the overhead quite a bit (QS is amazing, wonderful and cool, but yeah,...

I normally do try.  I even violated my own decision to "black ball" someone last night and tried to figure out what the heck it was they were talking...

Yeah, Jack's right. Query Store is a good way to go. It does aggregate the data you get (by the hour by default), so if you need detailed info, XE...

I shy away from the ring buffer as an output mechanism. It puts quite the load on the monitored machine. Instead, I'd suggest using file output. You could then use...

I try to help. I really don't look at who it is. I try.

Now, if they get demanding. I walk away. No need to argue or whatever. I helped, or...

As you can tell, this is a huge topic. There's a lot to it. Honestly, I'd suggest you grab a copy of my book, link in the signature below this...

I am not aware of any.