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, 12 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...

I'd say there's not a single correct answer for everyone on this question, but I'll put out my two cents.

Yes.

I see three general tracks through work life (VERY broad generalizations...

Backup and restore is out. It simply doesn't work. The Azure systems are constantly being upgraded and backups from there generally can't be restored down to on-premises. It's similar to...

Potentially. If they're holding locks, even shared locks, anywhere, you could see contention because of it. However, I suspect you would have seen it by now.

Main concern would really only...

Nope. Sounds like the application, or applications, has a problem. Time to dig into the code & configurations there.

SQL Server is a greedy cuss. Running SSIS and SSAS on the same server is going to cause quite a bit of contention.