I didn't even notice it earlier, but the older version of the plan had a missing join predicate. The structure of this query is in dire straights.

How big are these...

You're still looking at 2.4 million rows estimated and 46.8k actual. That's an enormous disparity. What other functions do you have in there? You also have filters that aren't doing...

Not sure that's always...

HA!!

From the reviews I've heard, I was right though.

It's a real shame. I did love the universe set...

Don't put your face in them. I stopped recording videos about 9 months ago. I'm going to get back on it, but change the format a bit. No more "video"...

I hear you. Thinking about it some more, while a bit of a pain, I don't see any way this is dangerous. Sure, you have a few more files, so...

It's estimating 1.9 million rows and moving 500k. That's my first concern, not the spool. The spool is in place so that it doesn't have to do that scan over...

The better you get at communication, the better an employee you'll be. The better you get at communication, the more likely you'll get hired. Yes, if you communicate a ton,...

Honestly, testing and experience is going to be the answer. Does it sound like a reasonable approach to me? Yes.

Did you also post this question on Quora? It sounds like one I answered over there. My answer here would be largely the same.

As to a way to dip your...

Side note:

You know the missing index DMVs are just suggestions, right?

Further, there is no correlation between the missing index information and queries. Therefore, you can't know if the missing index...

Yes. The exact same queries you use to look at missing indexes in the boxed SQL Server product. Under the covers, Azure SQL Database is just SQL Server. If ever...

Yeah it's not the compression. That's fine. (although I know where you can get even better than native compression <cough> Redgate </cough>), it's the TDE with compression that can lead...

Don't forget, even with a log file, if the backup process ignored SQL Server transactions, the attach could still fail.

First, you can't do this on a server where the same database already exists. You must be doing this on a new, or different, instance of SQL Server.

Here's how...