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...

We did no index rebuilds were.  The conditions travel with the restores.  The same holds true with statistics.  We do, however, rebuild stats once each week.  It has not made...

My worst nightmare has come true.  We upgraded to 2022 and stuff is crawling now.  We turned off Query Store and went back to the old cardinality estimator and that...

Heh... apparently the OP has left the building!

Thumbs up to the previous 2 replies.  The code is in serious need of some real help and the Developers need to be taught how to write good code.  I'm...

@ericwenger1,

Any chance of you posting the CREATE TABLE statement along with the indexes and constraints?  We might be able to make some additional suggestions, once we see it.

I realize that this is a wicked old post but thought I'd add why I use a backup to NUL.

I do it for testing code demonstrations, especially demonstrations concerning "Minimal...

Me too.  Where's the "Readily Consumable" test data and the desired results that match the test data?

With that being said, be advised... You've been asked to...

I might do that. I confess I've reached a point where I've learned not to ask. Asking tends never to get an answer, only stares. So, learn helplessness.

Still, I'd...

hi,

Just an observation I was trying to make sense of. I'd appreciate anyone's explanation for why this happens.

I've got a table field with datatype varchar(10). If a value greater...