You can also do a query against the DMVs to see what's currently in cache in terms of queries against the databases. It won't show the kind of detailed activity...

Hi.

Full disclosure, I work for Redgate. So, you can weigh everything I'm about to say.

Microsoft has a tool built into Visual Studio, so you have to have a license for...

Honestly, Azure or AWS is what I would suggest.

Are there third party things? Sure. Are they applicable to a broad enough swathe of the landscape that it's going to help...

You would need some different filtering on the waits. You can't simply correlate them through causality tracking and then only capture the related waits. Instead, you also need to filter...

Jeff. Your ears should be burning. I've had a few conversations about you & fragmentation over here in Belgium with a bunch of people. Happy to hear you've...

Jeff. Your ears should be burning. I've had a few conversations about you & fragmentation over here in Belgium with a bunch of people. Happy to hear you've stopped smoking....

It would be the standard stuff, sql_batch_complete or rpc_complete. With the batch completion event you can filter by the search string. With the rpc_complete you'll need to first identify stored...

And you, you should not be in fear for your job. Ha!

You've hit it on the head. I love this stuff. I do. However, like anything, used badly, it's going...

Well, SSDT for Visual Studio 2022 is out as well, so the OP does have a choice of the latest or previous version for Visual Studio 2019 at least....

Yep. You need the latest version to work on the latest version. Forwards compatibility is generally not a thing.

Also, seems that you could be hitting a common problem. Scroll to...

OK. There's a ton to unpack here. Let's try to go through it.

Hello ,

I will proceed in the next few days to configure the columnstore indexes to replace the...

• This reply was modified 3 years, 7 months ago by Grant Fritchey.

Basically, it's a marker that something might be suspect, not that it is. So, you go and run a consistency check. If it finds something, there you go. If not,...

Statistics updates are way more of an art than a science. However, every two weeks, might be a little long. As a general rule, I updated stats once a week....

If you move your database to managed instance, you can't back it up and restore it locally again. Think of MI as a newer version of SQL Server. Just like...

Sure sounds like parameter sniffing. Running the code locally do you hard code the value, meaning:

SELECT x.a
FROM dbo.mytable as x
WHERE x.b = 42;

I would expect that to...