Thanks Grant.

Yes, had a feeling that might be the case

It's an exercise I haven't done for some time so it's always worth finding out if there's something new out there.

Oh...

• This reply was modified 2 months, 1 week ago by  DamianC.

Thanks Jeff

As it stands stats updated and indexes rebuilt

Also, proc cache cleared

It now runs through but still creates a different plan (same as before) with huge estimates

Thanks Brian

Yes, all same patch levels, the view is identical and there are no cross database or linked server joins used

The plans are different

The good plan uses an index seek...

I've tried, Jeff

It runs daily so it's fairly easy to just run an update statistics on all the tables involved

No impact i'm afraid

Something like

https://www.fourmoo.com/2014/02/06/ssas-configuring-the-slice-partition-in-your-cube/

http://sqljason.com/2012/01/set-slice-on-your-ssas-cube-partitions.html

I also found one that specifically said ensure slicer is set but cannot find that

I did, thanks Jeff

Worked it both ways (with and without GENERATE_SERIES) as I have a 2022 and a 2016 instance

The suggestion by Thom works, the window amendment by drew also...

I did, thanks Jeff

Worked it both ways (with and without GENERATE_SERIES) as I have a 2022 and a 2016 instance

The suggestion by Thom works, the window amendment by drew also...

perfect, thanks

Yes, I'd defined VALUES incorrectly - typing rather than cut and paste

That's an interesting thought.

Thanks Jeff - I'll try out these approaches

Great, thanks Grant

I will crack open Extended Events and see what results that brings

Thanks

Strange, it's not letting me attach the plan - 'Sorry, this file type is not permitted for security reasons.'

Sure I've attached sqlplan files before

This all makes sense

Yes, I suppose the...

I'm using SSIS data flow for insertion

From OLE DB to OLE DB

I'm finding that Page compression on a clustered index on the destination table i.e. leave in place, doubles the...

• This reply was modified 3 years, 7 months ago by  DamianC.

Thanks Scott

Cost threshold is 75

There are no non-clustered, just the clustered

I thought that initially Scott

but, there are 2 seperate tasks both indepdant and both sequential; 1 to populate the table then a second to create the index

It's waiting on the...

Thanks

Yes, it's wholesale

Fragmentation post population does not appear to be an issue, so doesn't need rebuilding (99.4%)

If I leave the CIX in place (i.e. don not drop and recreate) and...