I clearly have biases. When I'm not talking about a pure, non-Redgate, topic, in short, stuff that can be construed as marketing or sales, I just try to be incredibly...

Ooh, I would not solve this by going to VARCHAR(MAX). That could cause all sorts of performance problems. If you really have to go through this exercise, the answer is...

It can't be turned on with the secondary in 2019 or less (2022 only). When the primary fails over, it will have Query Store and the last good plan enabled...

The suspended state just means it's a connection waiting for a query to run. It's not actively using resources (well, a tiny amount of memory maintaining the connection). Did you...

Nah, you can turn off whatever you want. You'll lose some pretty sophisticated SQL Injection protection and a few other things.

I was referencing Query Store and ExEvents as a way...

Then walk through all other roles and groups that the login is associated with. Something has gone south.

Not much data to go on, but that looks like a pretty benign thing. It's had 3 seconds of waits over however long it's been connected (can't see that in...

Also, you sometimes see this kind of thing when thresholds are crossed such that the row counts change and different execution plans get generated. Over time, statistics and data distribution...

Take a look above at the "Stairways" menu choice. Inside there are tons of classes, including several on T-SQL fundamentals. They're 100% free. Go here.

Just for clarification, each execution plan is only, ever, for a given query. Sure, a batch or procedure might have 50 queries, but there will be 50, individual, execution plans...

Is your user in the public role? If not, that could be it. That's required to access sys.dm_os_host_info per the documentation.

Ken is correct, query store only works on the primary prior to 2022.

Yeah, query store is database by database, only, even in 2022. So each database gets it's own store....

Also, Azure SQL Database is backed up for you. Further, there is no capability for you to do a traditional backup. Instead, you can create what's called a...

I don't have a degree. Will I get the degree if I answer the question?

Please, no, don't start throwing hints all over it. Instead, focus on getting the execution plan and understanding what it is telling about how the query is behaving and how...