Total agreement with Erland & Thom.

Aggregates and analysis queries. That's where it shines. A really simple GROUP BY on a larger data set will immediately show the benefits. Columnstore works well with aggregates and large...

I was told (but have not tested) that Extended Events cannot return the query that is causing an event.  If that's not true, then my apologies and I'll go...

What do you mean on this one Jeff? I'm not aware of anything that Trace/Profiler...

I'd suggest capturing the execution plans for both versions of the query and compare them. You can use the estimated plans just fine, you don't need the actuals for this....

I'm not sure how you'd accomplish this to be honest. Microsoft's focus is on moving you into Azure, not out of it. Probably, your best bet, would be Azure Sync...

If you've set nothing up for monitoring queries, then your only option is to use the Dynamic Management Views (DMV). There are a few directly related to queries:

sys.dm_exec_query_stats

sys.dm_exec_procedure_stats

You could set up your firewall (and please, tell me you have one) so that it only allows connections from specific IP addresses or IP address ranges, that would make...

Oh yeah, I'm not complaining that people don't use it EVERYWHERE. I'm complaining that people don't use it, even in places where it would offer a clear advantage.

If the exec plans are the same, it's got to be a difference elsewhere. Database settings (probably not since this is a restore), server settings, os  settings, vm settings. Something...

Under most circumstances, not getting into data skew, bad column choices, etc.

Yeah.

In fact, having an index on C1 or an index on C1 and C2 as keys would be effective...

I don't have specific data, but I think it's the same reason that people are shy about using Extended Events.

In 2008, Extended Events were introduced, but, weren't quite functional. In...

Heh... guess I'm more ancient.  I've not found much that will actually beat BCP...

Yeah, I am ancient. I'd still pick SQLCMD or PowerShell over bcp though.

If you can't reset to capture the older plans, you're stuck. Code modification is the best way to go. You could also look to plan guides to supply the hint.

Most...