Is the E drive present and can you see databases and open files on that drive?

NULL is an unknown value. How many apples are there in the kitchen? NULL...

Probably not, since it's about Policy-Based Management.

Because there's no un-aggregated columns being returned from that subquery. Group By is only needed when you have columns in aggregate and columns that aren't in aggregate in the select...

Coalesce is how you do this. You're getting the error because the data types are different, SQL's trying to do implicit conversions and fails. All the entrie in Coalesce must...

I do not like in-place upgrades for production servers. If anything goes wrong in the upgrade (and I've seen it happen), then you're left with a non-working system.

TempDB however may well need its own drive or two, depending how much load is put onto it.

The tool adverts are a common spam here. Mention 'corruption', and you get a pile of them.

We might be able to help more (and maybe even get the data back...

It's the beginning of the SQLSaturday madness for me. 3 SQL Saturdays, 3 cities, 3 weeks

Abort reason is "Good enough plan found" (properties of the SELECT). Optimisation has multiple phases, "Good enough plan found" means that at the end of one phase the cheapest plan...

The execution plans please, not pictures of them. As in, the XML plans saved in as .sqlplan files.

Can you post the actual execution plans of both please?

It's probably a case if 'good enough', but there might also be some estimation differences resulting in the plan you didn't...

Edit: ignore.

dan-572483 (9/1/2016)

---

We have a new process to run updates on it that takes forever, so it needs a primary key or at least a unique index. One column already has...

And with no details about what it'll be used for, how it will be accessed, where the data comes from, what reliability is required, what performance is required, etc, etc,...