Ah, sorry I misunderstood.

If they were switched to read only on you, it's likely something to do with size and the cleanup management. The size-based cleanup should be a backup...

So, SQL Server is time-tested and extremely reliable. It simply does not randomly provide values based on whims or anything like that. It is ALWAYS down to the code, structures,...

Mirrored databases can't be written to, right? If so, then I'm pretty sure Query Store won't work on a mirrored database. Same as AG. It doesn't work there either (except...

Cool! Can you detail a little more for the person who has the same question as you so that they can see the answer too?

Looks like a monitoring query. It's probably being run from a monitoring tool. I've no idea how to tell you when it will next be executed. I'd suggest you use...

Microsoft has a couple of good examples. I'd strongly suggest you use option 2.

But!!!

The bigger question is, how did that happen in the first place? Cleaning it up is...

Share a little history, the compare engine in Visual Studio was licensed from Redgate years ago. Now, we've been tuning our engine since then. I don't think Microsoft has shown...

ddltbl

I promise, you'll never guess what that means. Never, ever, never. It was part of a naming standard at my old company that I raged against until it went away....

So, probably not going to have a single book that explains "each topic in full depth".

I have two books that I've written, totaling about 1,300 pages between the two of...

It can be a weird line here.

At my previous job, we were moving our entire data center from one building to another. As part of it, we wanted to, just...

The lack of a response is pretty sus too.

Why are you duplicating this question? I don't see a link suggesting this is spam, but the answers to that almost identical question are going to be what you...

This...

Yeah, it's as @Ant-Green has it. You have to have the live data window open first. It only shows active events. However, you can directly open the file, and it...

A whole bunch more functionality available in Extended Events. Here's a blog post showing how to use them to troubleshoot timeouts. There's also other events mentioned in the post...