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 4 years, 3 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.

Sounds like the transactions are closing and then opening again.

If the question is, how to run a bunch of scripts at once, I'd suggest taking a look at Powershell threading. It's a pretty easy way to launch a...

According to the documentation I'm familiar with, pure SQL Server replication is only supported with AWS RDS as a Subscriber. It's a mechanism to get you into AWS RDS. However,...