There are a number of things that could result in those figures not lining up, but the main thing is that sys.dm_exec_query_stats only has information for plans that are still...

If my memory serves me correctly, in Hungarian 'ly' is its own letter.

Seems to account for those results, e.g., 'GL' is a two letter string consisting of 'G' and...

Another way to try is to unpack the ranges into their constituent values and then do a join based on equality to those values.

Sometimes that's slower, but at least with...

Nah, many of our customers are baffled by this when they see it the first time too (and so was I when I first started playing with indexed views...

Are you using columnstore indexes?

Documentation for that wait type is basically nonexistent (Paul Randal's compendium has it, but says nothing other than that it was added in 2016).

Since it...

This has gotten a bit meandering, so let me see if I can summarize what's happened so far before I suggest anything.

You have a stored procedure for which you want...

Thanks for that update!

From looking at the log it looks like it probably is something along the lines of what Kevin suggested.

For both failed and successful full backups, there's a...

Do you perhaps have a read-only filegroup?

https://support.microsoft.com/en-us/kb/928518

Cheers!

The plan that uses seeks is actually quite a bit less efficient than the one that uses a scan, for a couple reasons.

First, the seek operator that is the outer...

Another good bit of info to get would be whether most of the data backed up for the large differentials is from the data files or the log file.

Something like...

WayneS (10/6/2016)

Sean Lange (10/6/2016)

Ed Wagner (10/6/2016)

Yeah, that's a good...

Really? Is the documentation...

Actually, that's not really true.

The log...

The detail on JOINs is in a different section from the one you cited, "U-SQL SELECT Selecting from Joins", one level down the tree from the "U-SQL SELECT FROM Clause".

That...

The Dixie Flatline (9/26/2016)

you should specify the window frame (generally ROWS UNBOUNDED PRECEDING), because the default is RANGE UNBOUNDED PRECEDING, and which is much slower than specifying the range...