</pedantic>

Yes

Having done this recently, multiple times, make the distributor SQL 2014 and do the entire setup from Management...

Drop the indexes. Then, once they're dropped run CheckTable on the two tables and see if there's any corruption remaining.

Seconded. It's excellent.

Basically, you don't.

From Books Online

"TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not...

The output already lists what the affected objects are.

CHECKDB found 0 allocation errors and 588 consistency errors in table 'ep1.EDIDS' (object ID 81643584)

CHECKDB found 0 allocation errors and 34 consistency...

No, because there will be other errors that indicate which object it's part of.

Without seeing the entire output of CheckDB I can't tell you how to fix it.

It's part of the corruption.

Someone\something is running BACKUP LOG <db name> WITH NORECOVERY as that backs up the log and then switches the DB into the RESTORING state.

Probably a backup dialog or job...

Can you pull the estimated plan from SQL 2014 and the actual plan from 2008 R2 and post them both?

There are two predicates, so the expected cardinality is multiplied together

If the first is expected to affect 50% of the rows and the second 20% of the rows, then the...

ChrisM@Work (2/10/2016)

GilaMonster (2/10/2016)

My comments had nothing to do with what the function returns, rather where to use it (not in a...

"Next version" always means next major version, not next service pack.

Upgrade advisor is for upgrading major versions (eg to 2012 or 2014), it doesn't check anything regarding applying service packs

Can you perhaps give more information? To start, what are you trying to do, to what, with what, etc, etc.

My comments had nothing to do with what the function returns, rather where to use it (not in a DML statement...