It's extremely situational. It depends on your region of the world, the services you offer, your level of experience, your level of reputation, and finally, whatever the market will bear....

Please don't cross post questions. It makes the conversation difficult to keep track of.

I posted one answer over here. Please, anyone else, continue the conversation there.

1) No. It doesn't work like that. The only issue possible is if, let's say, you created a giant table, then added data to other tables, and then deleted the...

I think what you're going for is best satisfied by using UNION ALL (bit of a guess). The key is that each of the two SELECT statements have...

Strong recommendation, turn on query store on the databases you migrate from pre-2014 servers to post-2014 servers (2016 or greater). Leave the database in the old compatibility mode for a...

First up, check the connecting settings between your SSMS and the clients calling the procedure. There may be differences. Also look at the execution plans to see if they are...

Ah, if you're already using Azure storage, then it clearly is all a Microsoft issue. Wonder if this counts as a noisy neighbor situation?

Two things, migrate the BACPAC file to Azure storage first, then import it to the database. Also, make sure you're using an adequate service tier for the imports. It does...

It's a somewhat tough subject to address. I'd say, make sure, just like any index, that the statistics are up to date. That's more important than anything else.

Nope. Not normal. So...

How are the measures being done? I'd suggest doing the measures on the server using extended events (or, if this is really 2008, trace events)....

There are exceedingly few books on any topic in Azure because it moves too quickly for most of us to write a book on the topic. There are however tons...