Shirting gears back to my previous thoughts, I'm not sure why we're even talking about the PERCENTILE_* functions.  They're a hundred times slower than Peter Larsson's method of using OFFSET/FETCH. ...

After you finally do get your restore to work, then you really need to look at your backup plan with the idea of quickly doing restores in the future.  Putting...

Indexes aren't going to help much here.  The OP is trying to return most of the table to the screen and there are a million rows in the table.  What...

One more BTW.... I was going to test performance of the PERCENTILE_CONT function against some other methods.  With the disclaimer that I've not verified the testing (and it DOES need...