Yep. Pretty much.

Ha!

The optimizer will absolutely rearrange your WHERE clause. It's part of how it works. It'll also rearrange and reorder your JOINs. So, from the most simplistic approach, WHERE & JOIN...

Just piling on with @ratbak

Every object in your queries should be qualified with the schema owner. If for no other reason, it reduces, in ever so tiny an amount, the...

Thanks everyone for the feedback so far. All jives with my understanding. I've just never heard the phrase "healthy deadlocks" before, so I was curious what others thought.

Question for the smart people, and the rest of you.

Would you endorse or get behind the statement:

Some deadlocks are healthy.

or

Some level of deadlocks is healthy.

Or is more something like:

Some level...

Backups should be run serially. I tried running them in parallel. It's a great way to bring down a server. So yes, most tools, software and suggested solutions, show backing...

If you're just looking at hosting a container, all the cloud vendors do it. Amazon ECS is one option. Azure Container Hosting is another. Pricing-wise, they're pretty similar. Better to...

If you're looking for truly legit certification courses, I'd suggest starting with Microsoft. There, they list a bunch of partners that offer up-to-date training. If you want online, Pluralsight...

What did you do?

Just so someone who finds your question also knows the answer.

If it makes you feel better 19 (in beta) isn't installing very quickly either.

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