It's all about the fundamentals. If every single thing is equal, so should performance be. So things are not equal. It's a question of walking through and figuring it out.

First...

Everything Jeff said.

But, one exception, columnstore indexes. Reorganization and rebuild do things...

On the missing index views? They just don't say anything. I'm not talking about all the other DMVs. They're vital. 1 million percent so. But the...

On the missing index views? They just don't say anything. I'm not talking about all the other DMVs. They're vital. 1 million percent so. But the missing index...

On the missing index views? They just don't say anything. I'm not talking about all the other DMVs. They're vital. 1 million percent so. But the missing index DMVs? Useless...

I like the answer from @DNA_DBA. That's a great approach. To that I would add, query the cache to see what kind of queries are being run on the system....

Generally speaking, the missing index recommendations taken from the DMV tables are useless. That's because they are not, and cannot be, linked to a given query. So you just have...

I've seen no types of standard degradation between 2017 and 2019. So, I'd suggest examining all the server settings, cost threshold, the things already suggested here.

Are you looking at servers, VMs, or are you looking at Azure SQL Database? How big are the VMs you're looking at, memory, cpu, disk, etc? For such a small...

IF your login and the service account are different (and oh, I hope they are), then your login may not have the same access to the underlying OS as the...

Homework?

A company can have many workers. So, you already have two tables. Company has many workers. Probably the company is the parent, the worker is the child. So, the PK...

Up front, not an expert in your programming language, Macs or MySQL.

Sounds like you're building a cloud-based app. I'd say you need to have a cloud-based database. I'd look to...

Are you trying to get up to the moment recovery, or do you just want a copy of the database and transactions that may, or may not, be in flight...

So, the logs in log shipping can be used as point in time recovery. Therefore, secondary log backups seem redundant, and yeah, they could lead to a truncation in the...

I get it. Dealing with NULL is a pain. However, it's a unique value and has unique functions. Follow Phil's advice. Use IS NULL and IS NOT NULL instead of...