You CAN, however, create a simple "Pass through view" that will do the trick.

Are the rows all at the "end" of the Clustered Index or are they scattered throughout?

As a bit of a sidebar, be aware that Page Compression causes index rebuilds to take...

I sure don't mean for it to be false praise, or even praise for nothing. I've just seen a few people get... for want of a term, upset when...

Lordy... I've been bitten by that before.  In this case, it returns 8K because it wasn't predefined as a MAX datatype.

Let run the test a bit...

I feel that your most needed confidence is that needed for you to ask questions when you are not sure about something.

One of my biggest regrets is in not...

Just to be absolutely correct, you might want to add a PK on EmpID in the Employee table. 😀

Otherwise, awesome question!

Actually, REORGANIZE does a whole lot...

It causes log file explosions.

It perpetuates fragmentation because it doesn't clear the pages above the Fill FACTOR.

It combines pages at the worst time possible, which...

I'm still waiting on the OP for the DDL and Data sources for the example table.

As a bit of a sidebar, I've not yet done a deep dive on this...

There's really no difference between CTEs and Views.  The exception to that rule is that if you can force a "Blocking Operator" in the CTE, it can act more like...

This is nice but I agree with Mike01.  Where do we get a copy of the DDL for the table AND the data?  People can learn much more by actually...

Just so people know, we have a "Morning Jobs Report" that we have extensive history from.  It includes the start DATETIME for each job and the duration.  It runs religiously...

I would say that it would be more useful (for Microsoft and the overall community) to provide some more specific detail about what sort of code or query patterns...

I don't know that Bob Ward is the best person to ping about this. Conor or Derek Wilson might be better resources.

I got similar results for the little loop...

Agreed but Bob Ward was they one that...